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

129 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
hookups163327(None) 
hookup1534421hookup_
lookups1332951lookups
cockups1735222cockups
hokums1533922h_okums
holdups1333592holdups
hookahs17446662hookahs
hookas135312502hook_as
hookers144916522hookers
hookeys17448962hookeys
hookies144017442hookies
hooks125027122hook__s
hoops105621072hoo__ps
lockups1534242lockups
lookup1233452lookup_
mockups1733342mockups
workups1633612workups
backups1736173backups
blowups1433163blowups
boojums1842653boojums
bookers134016613bookers
bookfuls1743463bookfuls
bookies133819403bookies
bookoos1337503bookoos
books115729713book__s
checkups2142803checkups
chooks155312793chook__s
cockup1635713cockup_
cookers134619463cookers
cookeys16478503cookeys
cookies133719273cookies
cookouts1446003cookouts
cooks115429143cook__s
cooktops1644063cooktops
coops96229643coo__ps
coups95522473_co_ups
croups104312553cro_ups
doofus1036163doofu_s
doowops1363943doowops
foldups1332733foldups
fuckups1832923fuckups
gooks105422883gook__s
goops86620963goo__ps
groups94210513gro_ups
haikus13538293haiku_s
hakus125114113h_aku_s
hangups1364823hangups
hiccups1643223hiccups
hockers163915913hockers
hockeys19509273hockeys
hocks144925493hock__s
hocus104715203h_ocu_s
hognuts1134183hognuts
hokes126231643h_ok_es
hokku1135483hokku__
hokum1436773h_oku_m
holdup1245183holdup_
holks124720563holk__s
honkers143315233honkers
honkeys17439513honkeys
honkies143015143honkies
honks125124523honk__s
honours10339383honours
hooches153812523hooches
hoodies113419833hoodies
hoodlums1443283hoodlums
hoodoos11109293hoodoos
hoods95124083hoo__ds
hooeys125512323hoo_eys
hoofers134513333hoofers
hoofs115721043hoo__fs
hook116133283hook___
hooka125513903hook__a
hookah16488243hook_ah
hooked145320553hook_ed
hooker134820173hook_er
hookey164713933hook_ey
hookier143811673hookier
hookiest152712103hookiest
hooking153716693hooking
hookless151238363hookless
hooklet142510813hooklet
hooklets15217203hooklets
hooknose1544273hooknose
hooky155220263hook__y
hoop96129983hoo__p_
hoopers123616493hoopers
hooplas1239213hooplas
hoopoes121212483hoopoes
hoopoos1298543hoopoos
hoorahs13399613hoorahs
hoorays13418383hoorays
hooters104520483hooters
hoots84830253hoo__ts
hoovers134312713hoovers
hooves124815493hoo_ves
hops97942633h_o__ps
hours85422393h_o_urs
howks155016853howk__s
kickups1443503kickups
kooks85217263kook__s
linkups1333633linkups
lockup1434763lockup_
lookers114014073lookers
lookouts1244563lookouts
looks95124863look__s
loops75723963loo__ps
loups75319623_lo_ups
markups1534963markups
mockup1634073mockup_
nookies113414963nookies
nooks95420393nook__s
oakums1264153_oakums
oops65232673_oo__ps
pickups1754253pickups
poops94422413poo__ps
rookies113917103rookies
rooks95325043rook__s
roups75118903_ro_ups
shooks134515633shook__s
sooks94425453sook__s
soups75322943_so_ups
stoups85313273sto_ups
tossups964023tossups
walkups1633013walkups
whoops14487863whoo__ps
woops104917523woo__ps
workup1534323workup_
zooks184716943zook__s

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 Limit1340271296.90619407.3
3Display Results1291290.0304300.0
 (SQL Overall)1786911297.37224239.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.