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

158 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
lookup123345(None) 
hookup1534421hookup
lockup1434761lockup
lookups1332951lookups
cockup1635712cockup
hookups1633262hookups
linkup1245122linkup
lockups1534242lockups
look87333472look__
looked114717072looked
looker104816952looker
lookout1148032lookout
looks95124862look_s
loop67835012loo__p
loup66028432l_o_up
mockup1634072mockup
workup1534322workup
backup1646613backup
bloop96116153bloo__p
blowup1335063blowup
boojum1733843boojum
book106836333book__
booked135319503booked
booker124719193booker
bookful1644763bookful
bookie123516003bookie
bookoo1248343bookoo
books115729713book_s
closeup11113433closeup
cockups1735223cockups
cook107236933cook__
cooked135921363cooked
cooker124722453cooker
cookey155414333cookey
cookie123716043cookie
cookout13410143cookout
cooks115429143cook_s
cooktop1544043cooktop
cooky145321363cook_y
coop87238653coo__p
coup86729793_co_up
croup95616783cro_up
doofus1036163doofus
doowop1283853doowop
foldup1233813foldup
fuckup1733963fuckup
gook96429603gook__
gooks105422883gook_s
gooky135818033gook_y
goop75829483goo__p
group85413923gro_up
hokku1135483hokku_
hokum1436763_hokum
holdup1245183holdup
hook116133283hook__
hooka125513903hook_a
hookah16488243hookah
hookas135312493hookas
hooked145320553hooked
hooker134820173hooker
hookey164713933hookey
hooks125027123hook_s
hooky155220263hook_y
hoop96129983hoo__p
kickup1354133kickup
kook75822603kook__
kookie9389833kookie
kooks85217263kook_s
kooky114412873kook_y
larrup835713larrup
layup1037723l_ayup
leku86519913l_eku_
letup73712163l_etup
lineup835983lineup
linkups1333633linkups
lock106134363lock__
locked134921663locked
locker124019423locker
locket123922473locket
locknut1345253locknut
lockout1359333lockout
locks115126923lock_s
locum94812173l_ocum
locus74819993l_ocus
lollop8238783lollop
loo38359823loo___
looby108115623loo_by
looed64626133loo_ed
looey84822913loo_ey
looeys95110123looeys
loof78141053loo__f
loofa85912813loo_fa
loofah12375813loofah
loofas9429833loofas
loofs85623783loo_fs
looie55624243loo_ie
looies65025833looies
looing73621043looing
lookers114014073lookers
looking123415043looking
lookism1335913lookism
lookist1139563lookist
lookouts1244563lookouts
loom67035053loo__m
loomed94616763loomed
looms75124643loo_ms
loon47344793loo__n
looney94712403looney
loonie64216453loonie
loons55731723loo_ns
loony86918963loo_ny
looped95217173looped
looper83817113looper
loops75723963loo_ps
loopy105316643loo_py
loos49051123loo__s
loose56627683loo_se
loosed75520893loosed
loosen66615963loosen
looser65219943looser
looses67328243looses
loot46955823loo__t
looted74421113looted
looter64222323looter
loots55431423loo_ts
lop58255313l_o__p
lotus55718063l_otus
loud55228043l_o_ud
loupe75319513l_o_upe
loups75319623l_o_ups
lour45430683l_o_ur
lout45952143l_o_ut
markup1436903markup
mockups1733343mockups
nook85728493nook__
nookie103712433nookie
nooks95420393nook_s
nooky124814813nook_y
oakum1177313_oakum
pickup1655633pickup
poop86532813poo__p
rook85532033rook__
rooked114918143rooked
rookie103613263rookie
rooks95325043rook_s
rooky126117623rook_y
roup66627693_ro_up
skookum1241503skookum
sloop76118913sloo__p
sook84933393sook__
sooks94425453sook_s
soup66232913_so_up
stoup75517073sto_up
took86531073took__
tossup875293tossup
walkup1534193walkup
workups1633613workups
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 Filter1786911127160.1531167915.0
2DLD Change Limit1127161586.44017502.5
3Display Results1581580.0463434.8
 (SQL Overall)1786911586.63926915.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.