Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “laniard” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

188 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
laniard86852(None) 
laniards967311laniards
laniary1068011laniary
lanyard1167291lanyard
canard9314762can_ard
flancard1443372flancard
laggard10347622laggard
laird65417792la_i_rd
landward1345822landward
lanyards1266392lanyards
liard65418592l__iard
mansard1049312mansard
manward1349092manward
poniard1037582poniard
tankard1267262tankard
tanyard1167182tanyard
vanward1456942vanward
aboard9312613_aboard
afeard1058263_afeard
anear55420323_anear_
aneared8512743_aneared
anears63717183_anears
angary10311323_angary
antiar6317173_antiar_
antiars7314623_antiars
apiary113910383_apiary
ariary94114203_ariary
aviary12338413_aviary
award97118043_a_ward
bandaid11310483bandaid
banian8315383bania_n
banians9312033banians
bankcard1774023bankcard
barnyard1443783barnyard
bastard103012423bastard
bayard124411663ba_yard
blinkard1543043blinkard
briard94311293_briard
caird85717233ca_i_rd
canards10311203can_ards
canary11314693can_ary
canid85526343cani__d
caviar11310163caviar_
caviare1238373caviare
caviars1238623caviars
dastard9279703dastard
fanfare1336673fanfare
flancards1543183flancards
gabbard1336553gabbard
galliard10125753galliard
goliard936073goliard
haggard13377183haggard
halliard12125963halliard
halyard1476973halyard
hangar104114513hangar_
hangared1337573hangared
hangars114313493hangars
hayward1736413hayward
hazard1938403ha_zard
inward10310333_inward
janisary1843623janisary
janizary2742483janizary
kantar10311153kantar_
kantars11310033kantars
laari54415713la__ari
labara83712893la_bara
labia75219013labia__
labial84714343labia_l
labials9299873labials
labiate91313573labiate
labiated11109303labiated
lacier84020093lacier_
lactary1237853lactary
laggards11307053laggards
lahar83114263la_har_
lahars94013163la_hars
laid56439143la_i__d
lair45934153la_i_r_
lairds74711613la_i_rds
laired75216813la_ired
lairs55425873la_i_rs
lakier104716273lakier_
lalland83810183lalland
lamia75324323lamia__
lamiae84817453lamia_e
lamias85020613lamia_s
laminar93810283laminar_
laminary13337253laminary
lampad114510033lampa_d
lanai5319573lan_a_i
lanais6316793lan_ais
lanate6421263lan_ate
lanated8313203lanated
lanced93717723lan_ced
lancer84319973lancer_
lancers93616643lancers
lanciers10308543lanciers
land56337313lan___d
landau7310613landa_u
landaus8310343landaus
landed84619243lan_ded
lander74028483lander_
landers84026213landers
landlord1045163landlord
landmark1544153landmark
landwards1445503landwards
languid936623languid
langur7109303langur_
langurs889103langurs
laniaries9411223laniaries
lanital7310913lanital
lanitals837723lanitals
lanker104123003lanker_
lankier113711633lankier_
lanner64920603lanner_
lanners73618333lanners
lantana739603lantana
lantern7310013lantern
lapboard1355783lapboard
lapidary1454093lapidary
larboard1157663larboard
lard56742003l___ard
lariat6629043laria_t
lariated91212063lariated
lariats7615053lariats
lascar868573lascar_
lascars979013lascars
laterad8310843laterad
lazar144113643la_zar_
lazars153812393la_zars
lazied164610653lazi_ed
lazier154214613lazier_
leeward1135783leeward
lenited8812433lenited
leopard1045293leopard
leotard846193leotard
liar47229683l__iar_
liards75212613l__iards
liars54723163l__iars
linear65113343linear_
linier64423793linier_
lizard16369233l_izard
loanword1244413loanword
lunar57017313lun_ar_
lunars65012813lun_ars
lunier64617603lunier_
lyard95113213l__yard
mallard10310273mallard
mania75634153mania__
maniac103917973mania_c
maniacs114313063maniacs
manias84029033mania_s
mansards1148013mansards
manuary1237773manuary
manwards1447613manwards
mazard1838763ma_zard
mazzard1844463mazzard
naiad6313403na_ia_d
nard56634453__n_ard
onward1039053_onward
panier84425503panier_
paniers94717333paniers
placard1236783pla_card
plagiary1443643plagiary
planar84212713plan_ar_
plantar9369993plantar_
poniards1145823poniards
ranid66429333rani__d
saggard10358953saggard
sangar73617683sangar_
sangars83116253sangars
sanitary1146753sanitary
sansar63613393sansar_
sansars73313913sansars
standard1046253standard
sunward1137653sunward
tabard9313333ta_bard
tanbark1337373tanbark
tankards1366253tankards
tantara72410823tantara
tanyards1276183tanyards
unitard838003_unitard
vanguard1343893vanguard
vaward13498723va_ward
wanier93920683wanier_
wayward1736053wayward
yaird96111913ya_i_rd
zanier154314713zanier_

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.436409841.7
2DLD Change Limit1340271887.36018210.2
3Display Results1881880.0632984.1
 (SQL Overall)1786911887.85922737.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.