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 “loofahs” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
loofahs1336462(None) 
loofah12375811loofah_
loofas9429831loofa_s
hookahs17446652hookahs
hoorahs13399602hoorahs
loofa85912812loofa__
loofs85623782loof__s
lotahs9479872l_otahs
moolahs12347382moolahs
pooftahs1642362pooftahs
booths115313793boo_ths
confabs1435393confabs
coofs105924713coof__s
coolths1236013coolths
coprahs14338153coprahs
doodads1035093doodads
doofus1036163doof_us
dourahs11487253dourahs
goofs94821003goof__s
goombahs1642523goombahs
goorals838703goorals
hoofers134513323hoofers
hoofs115721043hoof__s
hookah16488243hookah_
hookas135312493hooka_s
hoorah124411113hoorah_
hoorays13418373hoorays
horahs126313873_horahs
houdahs1434243houdahs
howdahs1733613howdahs
kloofs13386353kloof__s
laogais845813laogais
loads65323373l_o_ads
loafers10349463loafers
loafs85616993l_o_afs
loams75619863l_o_ams
loans56026463l_o_ans
locals83714503l_ocals
lochans1248833lochans
lochs106715513l_o_chs
lofts85518363l_of_ts
logans76319063l_ogans
loggats9286453loggats
logjams1743583logjams
logomachs1751573logomachs
logways1434513logways
longans84510813longans
loobies93814103loobies
looeys95110123loo_eys
loof78141053loof___
looies65025833loo_ies
lookers114014073lookers
looks95124863loo__ks
lookups1332953lookups
looms75124643loo__ms
looneys10487013looneys
loonies73919543loonies
loons55731723loo__ns
loopers93914033loopers
loops75723963loo__ps
loos49051123loo___s
loosens716310953loosens
looses67328243loo_ses
looters74419163looters
loots55431423loo__ts
loquats1645273loquats
lorans65117603l_orans
lotah85315853l_otah_
lotas55926303l_ota_s
loughs105014773l_oughs
loumas84812333louma_s
lovats939073l_ovats
luffas12337483luffa_s
mollahs12328283mollahs
moolah11409193moolah_
moolas83615593moola_s
nonfans1037533nonfans
obeahs1135863_obeahs
odahs95610083__odahs
ofays11488923__ofays
offals1235893_offals
oohs75220693_oo__hs
oompahs1434263oompahs
oomphs1344723_oomphs
opahs105411983__opahs
poofs105222793poof__s
pooftah1543143pooftah_
poohs103915713poo__hs
roofers105013903roofers
roofies103014413roofies
roofs85321153roof__s
shofars1335833shofars
sofars94712783_sofars
sofas85320713_sofa_s
sooths95715593soo_ths
tooths96013803too_ths
torahs95115643_torahs
woofers133810583woofers
woofs114918003woof__s

Search took 7 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.406440125.6
2DLD Change Limit134027996.12321889.1
3Display Results99990.0333000.0
 (SQL Overall)178691996.56227231.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.