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 “lordlier” 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.

149 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
lordlier93536(None) 
loudlier934951loudlier
godlier938892go_dlier
goodlier1035792goodlier
lardier83518342lard_ier
lonelier838002lonelier
lordliest1036102lordliest
lordlike1345812lordlike
lordling1077742lordling
lovelier1136432lovelier
lowlier10338902lo_wlier
portlier1038372portlier
wordier112511212word_ier
worldlier1342162worldlier
bloodier1136823blood_ier
boodler103312003boodl_er
border94419973bord__er
borderer1168103borderer
burblier1255603burblier
burlier93514413bur_lier
clerklier1542183clerklier
cloddier1234063clo_ddier
cloudier1135053cloud_ier
coalier93416183co_alier
coddler113710833coddl_er
collier93618153co_llier
comelier12310653comelier
complier14310253complier
corder94322883cord__er
cordlike1537233cordlike
corkier133114303cor_kier
cornier93017093cor_nier
coruler9311713corul_er
costlier1038523costlier
courtlier1154463courtlier
cuddlier1234013cuddlier
curdier103312623curd_ier
curdler103511563curdl_er
curlier93314183cur_lier
darklier1335013darklier
deadlier1036863deadlier
dodgier10388243do_dgier
doodler93310153doodl_er
dorkier122810023dor_kier
dowdier12328573dowd_ier
droolier936073droolier
earlier72612743ear_lier
fondler11348883fondl_er
forkier144311593for_kier
girdler9227313girdl_er
girlier8289523gir_lier
gladlier1034343gladlier
glorifier1344233glorifier
gogglier1153923gogglier
gondolier1144723gondolier
gorier73719373gor__ier
gorsier83811073gor_sier
grodier939673grod_ier
growlier1234883growlier
hardier114721543hard_ier
holier94921623ho__lier
homelier1338983homelier
hoodier113812973hood_ier
hornier103012463hor_nier
horsier103013243hor_sier
hotelier1137633hotelier
hurdler113610003hurdl_er
jollier142911003jo_llier
jowlier17327563jo_wlier
kindlier1345763kindlier
ladler74314933l_adl_er
landler84113203landl_er
larder73720973lard__er
lardlike1336503lardlike
larkier113711523lar_kier
lavalier1146043lavalier
leadier83212723lead_ier
ledgier9458503l_edgier
likelier1235283likelier
livelier1136873livelier
loader74316313load__er
loamier9349163lo_amier
localizer20147713localizer
lodger86517693lo_d_ger
loftier1037763lo_ftier
loggier93811143lo_ggier
logier75015733lo__gier
logroller1042443logroller
loller63315283lo__ller
lollies73116923lo_llies
loonier73312683lo_onier
loopier93711193lo_opier
loppier11369723lo_ppier
lorded84916733lord__ed
lording93115233lord_ing
lordless9277483lordless
lordliness1144883lordliness
lordlings1143923lordlings
lordly1038753lordl__y
lordoses937143lordoses
lories64933043lor__ies
lorimer937753lor_imer
loriner7511893lor_iner
lorries74518343lor_ries
louder74414603loud__er
loudliest1035773loudliest
lousier72411623lo_usier
lovelies1139893lovelies
lowlifer1443283lo_wlifer
loyaler1035083loyal_er
marblier1256343marblier
marlier92614773mar_lier
moldier103110033mold_ier
moodier103212203mood_ier
moralizer2049473moralizer
motlier92010583mo_tlier
mouldier1154963mouldier
nerdier83110353nerd_ier
oilier64417233_o_ilier
orbier839993_or_bier
ordainer945223_ordainer
order65019363_ord__er
orderer8127943_orderer
outlier72216143_outlier
podgier11338723po_dgier
porkier133712343por_kier
pornier93413133por_nier
puddlier1234213puddlier
relier65826183__relier
roilier7311523ro_ilier
rowdier11348593rowd_ier
rulier65016353__rulier
soldier82812153sold_ier
sorrier72313733sor_rier
studlier935473studlier
surlier72915443sur_lier
tardier859719993tard_ier
toddler9379043toddl_er
torchier1337463torchier
unrulier845333unrulier
wobblier15325203wobblier
woodier113912063wood_ier
woodsier1245473woodsier
woolier103612353wo_olier
woollier1155433woollier
wormier12278763wor_mier
worrier102311683wor_rier
worthier1436713worthier
yodler10389943yo_dl_er

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621497.08020644.4
3Display Results1491490.0463239.1
 (SQL Overall)1786911497.54623680.2
 
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.