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

122 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
hoopoos129854(None) 
hoodoos11109291hoodoos
hoopoes121212481hoopoes
hoopoo1198751hoopoo_
booboos1138142booboos
boocoos1137752boocoos
boohoos1237992boohoos
bookoos1337502bookoos
doodoos9107622doodoos
holloos104013582holloos
hoodoo10109982hoodoo_
hoopers123616492hoopers
hooplas1239212hooplas
hoopoe11911232hoop_oe
hoops105621072hoop__s
koodoos12116392koodoos
voodoos1196342voodoos
booboo1039463booboo_
boocoo1039003boocoo_
boohoo1148833boohoo_
bookoo1248343bookoo_
bowpots1446023bowpots
compos124818803comp_os
coocoo1069693coocoo_
coopers114019483coopers
coops96229643coop__s
coopts105814583coop_ts
coupons112710563coupons
coypous14248813coypous
doodoo8108893doodoo_
doowops1363943doowops
googols935483googols
goops86620963goop__s
halloos103716743halloos
harpoon1238313harpoon
harpoons1337483harpoons
hippos13408433h_ippos
hobnobs1443603hobnobs
hoboes114717453h_oboes
hobos106321353h_o_bos
holloas103814943holloas
holloes103818193holloes
holloo94415253holloo_
hollos95320633h_ollos
hollows134412333hollows
hommos13128503h_ommos
homologs1448243homologs
homos105921793h_o_mos
honchos15369573honchos
honors94816793h_onors
hooches153812523hooches
hoodies113419833hoodies
hoodooed1344963hoodooed
hoodooism1553273hoodooism
hoods95124083h_o_ods
hooeys125512323hoo_eys
hoofers134513333hoofers
hoofs115721043h_o_ofs
hookahs17446663hookahs
hookas135312503hoo_kas
hookers144916523hookers
hookeys17448963hookeys
hookies144017443hookies
hooknose1544273hooknose
hooks125027123h_o_oks
hookups1633273hookups
hoop96129983hoop___
hooped125518183hoop_ed
hooper114518313hoop_er
hooping133615703hooping
hoopla1147633hoop_la
hoopless13279263hoopless
hoorahs13399613hoorahs
hoorays13418383hoorays
hoosgow1442763hoosgow
hoosgows1542923hoosgows
hooters104520483hooters
hoots84830253h_o_ots
hoovers134312713hoovers
hooves124815493hoo_ves
hopers114222973h_opers
hopes105835643h_op_es
hoppers143115143hoppers
hopples142810713hopples
hops97942633h_op__s
horrors1078693horrors
hotdogs1234453hotdogs
hotfoot1347053hotfoot
hotfoots1444323hotfoots
hotrods1148283hotrods
hotspots1344843hotspots
hulloos104010073hulloos
hypos1312014743h_yp_os
isopods1045573isopods
joypops2162603joypops
koodoo11107773koodoo_
loopers93914033loopers
loops75723963loop__s
monopods1347973monopods
morphos14159083morphos
nonpoor956483nonpoor
nonpros937473nonpros
oops65232673_oop__s
pompoms1535333pompoms
pompons1338553pompons
pompous1338063pompous
poops94422413poop__s
poos65949113___poos
shampoos1544603shampoos
sopors85215203_sopors
topos75726393_top_os
torpors939383torpors
uropods1035873uropods
voodoo10127533voodoo_
whoopees16294823whoopees
whoopers16286263whoopers
whoopies16267373whoopies
whooplas1644013whooplas
whoops14487863whoop__s
woops104917523woop__s
woopses1237883woopses
youpons12265983youpons

Search took 10 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 Limit1340271229.29614417.7
3Display Results1221220.0931311.8
 (SQL Overall)1786911229.79518243.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.