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 “lookups” 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
lookups133295(None) 
hookups1633261hookups
lockups1534241lockups
lookup1233451lookup_
cockups1735222cockups
hookup1534422hookup_
linkups1333632linkups
lockup1434762lockup_
lookers114014072lookers
lookouts1244562lookouts
looks95124862look__s
loops75723962loo__ps
loups75319622l_o_ups
mockups1733342mockups
workups1633612workups
backups1736173backups
bloops106611343bloo__ps
blowups1433163blowups
boojums1842653boojums
bookers134016613bookers
bookfuls1743453bookfuls
bookies133819403bookies
bookoos1337503bookoos
books115729713book__s
closeups12102803closeups
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
hokums1533923_hokums
holdups1333593holdups
hookahs17446653hookahs
hookas135312493hook_as
hookers144916513hookers
hookeys17448953hookeys
hookies144017443hookies
hooks125027123hook__s
hoops105621073hoo__ps
kickups1443503kickups
kooks85217263kook__s
larrups934733larrups
layups1133993l_ayups
letups8317683l_etups
lineups934913lineups
linkup1245123linkup_
lockers133516923lockers
lockets134612203lockets
locknuts1443683locknuts
lockouts1445493lockouts
locks115126923lock__s
locums10478303l_ocums
locus74819993l_ocu_s
lollops9227443lollops
loobies93814103loobies
looeys95110123loo_eys
loofahs13364623loofahs
loofas9429833loo_fas
loofs85623783loo__fs
looies65025833loo_ies
look87333473look___
looked114717073look_ed
looker104816953look_er
looking123415043looking
lookism1335913lookism
lookisms1444793lookisms
lookist1139563lookist
lookists1245713lookists
lookout1148033lookout
looksism1442493looksism
looms75124643loo__ms
looneys10487013looneys
loonies73919543loonies
loons55731723loo__ns
loop67835013loo__p_
loopers93914033loopers
loopy105316643loo__py
loos49051123loo___s
loosens716310953loosens
looses67328243loo_ses
looters74419163looters
loots55431423loo__ts
lops66043353l_o__ps
lotus55718063l_otu_s
louis57322323l_o_uis
loup66028433l_o_up_
loupe75319513l_o_upe
loupes84918053l_o_upes
lours55125293l_o_urs
louts56330273l_o_uts
markups1534963markups
mockup1634073mockup_
nookies113414963nookies
nooks95420393nook__s
oakums1264153_oakums
oops65232673_oo__ps
pickups1754253pickups
poops94422413poo__ps
rookies113917103rookies
rooks95325043rook__s
roups75118903_ro_ups
sloops85513623sloo__ps
sooks94425453sook__s
soups75322943_so_ups
stoups85313273sto_ups
tossups964023tossups
walkups1633013walkups
woops104917523woo__ps
workup1534323workup_
zooks184716943zook__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 Limit1340271226.26621389.6
3Display Results1221220.0304066.7
 (SQL Overall)1786911226.70226662.3
 
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.