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

137 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
dustups103391(None) 
dustup935361dustup_
cutups1036812cu_tups
dusters84918362dusters
dusts65923562dust__s
pushups1433652pushups
bestuds10326753bestuds
brushups1542713brushups
busters94724133busters
bustics11810883bustics
bustles93816323bustles
busts75227693bust__s
bututs8409423bu_tuts
catsups1135343catsups
cestus84412913cestu_s
cistus84611343cistu_s
cultus85110733cultu_s
cuscus1038113cuscu_s
cusps94913673cus__ps
customs11348263customs
custos84014313cust_os
cutup9410093cu_tup_
datums936353d_atums
desktops1542463desktops
dictums1235553dictums
disbuds11125243disbuds
discus94512113discu_s
discuss10357953discuss
diseurs839403diseurs
disrupt1048633disrupt
disrupts1145293disrupts
distils83015803distils
disturb1046233disturb
disturbs1145403disturbs
ducts85319893duct__s
ductule1065503ductule
ductules1155543ductules
duets65323883duet__s
dufus94010813du_fu_s
dugouts935043dugouts
duits65021883duit__s
dumdums1343043dumdums
dumps105220103du__mps
dunts65828413dunt__s
dups75929513d___ups
durums948153du_rums
dusks105317253dus__ks
dust57142533dust___
dustbin1044543dustbin
dustbins1144593dustbins
dusted83918373dust_ed
duster74919723dust_er
dustheaps1541873dustheaps
dustier83814133dustier
dustiest93015073dustiest
dustily113211523dustily
dusting93618993dusting
dustings10419033dustings
dustless9328353dustless
dustman1044683dustman
dustmen1035773dustmen
dustoff1445053dustoff
dustoffs1543163dustoffs
dustpan1043243dustpan
dustpans1143233dustpans
dustrag945363dustrag
dustrags1044943dustrags
dusty96018323dust__y
duties74921903du_ties
estops84011223_estops
frustums1342993frustums
fuckups1832923fuckups
fustics1279593fustics
getups9346853_getups
gustoes879873gustoes
gusts65722793gust__s
hustles103414173hustles
insteps936573insteps
justers143815733justers
justles143311433justles
justs124918263just__s
kulturs1134723kulturs
letups8317683_letups
lusters73921443lusters
lustres73013233lustres
lustrums1044663lustrums
lusts55022803lust__s
lusus54813873lus_u_s
muktuks1242253muktuks
museums1134563museums
mustees94614923mustees
musters94522513musters
musths11589483must_hs
musts75527443must__s
ousters74122793ousters
ousts55225703oust__s
pasteups1243493pasteups
postops11311713postops
pullups1134233pullups
pushup1335273pushup_
pustule937683pustule
pustules1038443pustules
rustics9810733rustics
rustles73416413rustles
rusts55026993rust__s
scups95316653__scups
setups83910463_setups
situps8538783_situps
soups75322943__soups
steps76619883__steps
stops74827283__stops
stoups85313273__stoups
stubs75016073__stubs
studs64415873__studs
stumps104912283__stumps
stums75320083__stums
stuns54719493__stuns
stupa74112313__stupa
stupas83910883__stupas
stupe75217753__stupe
stupes84116953__stupes
sunups837263su_nups
sups64834433__s_ups
tittups933353tittups
tossups964023tossups
tuneups933333tuneups
tups65628763___tups
turnups933893turnups
tussurs7356393tussurs
tutus55214813tu_tu_s
unsteps936213unsteps
unstops936993unstops
upsteps1133743upsteps
usques15126803_usques
usurps8105073_usurps
washups1534683washups
xystus16354423xystu_s

Search took 10 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.563317390.8
2DLD Change Limit1340271378.39015974.6
3Display Results1371370.0462978.3
 (SQL Overall)1786911378.99919856.8
 
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.