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

147 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
workup153432(None) 
workups1633611workups
cockup1635712cockup
hookup1534422hookup
lockup1434762lockup
lookup1233452lookup
markup1436902markup
mockup1634072mockup
walkup1534192walkup
warmup1335342warmup
work115528842work__
worked145314702worked
worker134715112worker
workout1448392workout
works125621902work_s
backup1646613backup
bork106933823bork__
borked135117293borked
borks115727703bork_s
cockups1735223cockups
corium10315723corium
cork106635693cork__
corked135020783corked
corker124720853corker
corks116028273cork_s
corky145221153cork_y
cornu75921323cornu_
cornua85411903cornua
cornus84816563cornus
corpus106015293corpus
corrupt1149103corrupt
coup86729793co__up
croup95616783_croup
dorbug1034953dorbug
dork96531463dork__
dorks105724443dork_s
dorky135518743dork_y
dorp76028053dor__p
dorsum947623dorsum
foldup1233813foldup
fork115930943fork__
forked145217143forked
forker134717903forker
forkful1744773forkful
forks125324683fork_s
forky156119643fork_y
forum108318763for_um
fuckup1733963fuckup
gorp75625903gor__p
group85413923_group
hokku1135483hokku_
hokum1436773ho_kum
holdup1245183holdup
hookups1633273hookups
jorum145513743jor_um
kickup1354133kickup
korun9411923kor_un
larrup835713larrup
linkup1245123linkup
lockups1534243lockups
lookups1332953lookups
loup66028433lo__up
markups1534963markups
mockups1733343mockups
morgue938113morgue
oakum1177313_oakum
orlop7410903_orlop
pickup1655633pickup
pork106929683pork__
porked134717623porked
porker124917543porker
porks115124143pork_s
porky145019333pork_y
porous84419483porous
roup66627693__roup
sirup74014913sir_up
sorus54527583sor_us
soup66232913so__up
syrup103010963syr_up
torous64319033torous
torque15237673torque
torus54329763tor_us
tossup875293tossup
turnup835093turnup
walkups1633013walkups
wark115737773wark__
warked144421213warked
warks127932403wark_s
warmups1433813warmups
warp95635003war__p
washup1435323washup
whaup13458883w_haup
whup125714163w__hup
wickiup18172673wickiup
wickyup21171883wickyup
wikiup15183533wikiup
windup1235383windup
woeful1236363woeful
woful1158173wo_ful
wok106334173wo_k__
woke115527963wo_k_e
woken124614973wo_ken
woks116224903wo_k_s
wonk116125303wonk__
wonks124818343wonk_s
wonky154011773wonk_y
wop87145133wo___p
word89832003wor__d
worded114316623worded
words95425073wor_ds
wordy126916163wor_dy
wore77144673wor__e
workbag1742923workbag
workbox2343313workbox
workday1843303workday
workers144612693workers
workhour1843613workhour
working153813253working
workman1635613workman
workmen1635933workmen
workouts1544963workouts
workshop2043973workshop
world96915363wor_ld
worlds10568733worlds
worm96129493wor__m
wormed124314303wormed
wormer114514913wormer
wormil1138043wormil
worms105320763wor_ms
wormy137514253wor_my
worn75631753wor__n
worrit92313313worrit
worry116114333wor_ry
worse86525263wor_se
worsen95513873worsen
worser95117523worser
worses95522953worses
worset96726583worset
worship1547833worship
worst86330133wor_st
worsts96014333worsts
wort76654753wor__t
worth117120523wor_th
worths127812893worths
worthy15598803worthy
worts88631183wor_ts
wrap96821973w_r_ap

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.376475242.0
2DLD Change Limit1127161475.56020272.7
3Display Results1471470.0463195.7
 (SQL Overall)1786911475.98229871.4
 
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.