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

113 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
workups163361(None) 
workup1534321workup_
cockups1735222cockups
hookups1633272hookups
lockups1534242lockups
lookups1332952lookups
markups1534962markups
mockups1733342mockups
walkups1633012walkups
warmups1433812warmups
workers144612692workers
workouts1544962workouts
works125621902work__s
backups1736173backups
borks115727703bork__s
cockup1635713cockup_
corkers134118853corkers
corks116028273cork__s
cornus84816563cornu_s
corps95927043cor__ps
corpus106015293corpu_s
corrupt1149103corrupt
corrupts1244983corrupts
coups95522473co__ups
croups104312553_croups
dorbugs1132983dorbugs
dorks105724443dork__s
dorps85419223dor__ps
foldups1332733foldups
forceps14466983forceps
forkers144615783forkers
forkfuls1843553forkfuls
forks125324683fork__s
forums114611843for_ums
fuckups1832923fuckups
gorps85316993gor__ps
groups94210513_groups
hokums1533923ho_kums
holdups1333593holdups
hookup1534423hookup_
jorums15408093jor_ums
kickups1443503kickups
larrups934733larrups
linkups1333633linkups
lockup1434763lockup_
lookup1233453lookup_
loups75319623lo__ups
markup1436903markup_
mockup1634073mockup_
morgues1038273morgues
oakums1264153_oakums
orlops847303_orlops
pickups1754253pickups
porkers134314933porkers
porkies133416493porkies
porks115124143pork__s
porous84419483porou_s
roups75118903__roups
sirups83710533sir_ups
sorus54527583sor_u_s
soups75322943so__ups
syrups11277953syr_ups
torous64319033torou_s
torques16217513torques
torus54329763tor_u_s
tossups964023tossups
turnups933893turnups
walkup1534193walkup_
warks127932403wark__s
warmup1335343warmup_
warps107126423war__ps
washups1534683washups
whaups14405753w_haups
whups134210003w__hups
wickiups19181963wickiups
wickyups22171773wickyups
wikiups16132083wikiups
windups1334783windups
woks116224903wo_k__s
wonks124818343wonk__s
woops104917523wo__ops
wops96634153wo___ps
words95425073wor__ds
work115528843work___
workbag1742923workbag
workbags1843013workbags
workbox2343313workbox
workday1843303workday
workdays1942903workdays
worked145314703work_ed
worker134715113work_er
workhours1943193workhours
working153813253working
workings16337503workings
workless15276803workless
workman1635613workman
workmen1635933workmen
workout1448393workout
workshops2143933workshops
worlds10568733wor_lds
wormers124012573wormers
wormils1236733wormils
worms105320763wor__ms
worries104117133worries
worrits10258683worrits
worsens104610263worsens
worses95522953wor_ses
worsets105512843worsets
worships1647103worships
worsts96014333wor_sts
worths127812893wor_ths
worts88631183wor__ts
wraps105617153w_r_aps

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.406440125.6
2DLD Change Limit1340271137.06318975.9
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.51523777.9
 
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.