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

165 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
dustup93536(None) 
dustups1033911dustups
cutup9410092cu_tup
dust57142532dust__
dusted83918372dusted
duster74919722duster
dusts65923562dust_s
dusty96018322dust_y
pushup1335272pushup
adust64117453adust__
bestud9439303bestud
brushup1443513brushup
bust65947783bust__
busted95123153busted
buster84726493buster
bustic101012693bustic
bustle84015483bustle
busts75227693bust_s
busty105621013bust_y
butut75522913bu_tut
catsup1036433catsup
cestus84412913cestus
cistus84611343cistus
cultus85110733cultus
cuscus1038113cuscus
cusp86021063cus__p
custom104010273custom
custos84014313custos
cutups1036813cu_tups
datum8310633d_atum
desktop1442413desktop
dictum1136863dictum
disbud10165713disbud
discus94512113discus
diseur738843diseur
disrupt1048633disrupt
distal73615773distal
distil73616433distil
disturb1046233disturb
dost57248353dost__
duct75735463duct__
ductal938993ductal
ducted104012123ducted
ducts85319893duct_s
ductule1065503ductule
duet56446263duet__
dueted84113593dueted
duets65323883duet_s
dufus94010813du_fus
dugout8310363dugout
duit56241583duit__
duits65021883duit_s
dumdum1244523dumdum
dump95927093du__mp
dunt55746873dunt__
dunted84718503dunted
dunts65828413dunt_s
dup67637883d___up
durst66125173durst__
durum8513203du_rum
dusk95724153dus__k
dusked124112513dusked
dusks105317253dus_ks
dusky135213043dus_ky
dustbin1044543dustbin
dusters84918363dusters
dustheap1442323dustheap
dustier83814133dustier
dustily113211523dustily
dusting93618993dusting
dustman1044683dustman
dustmen1035773dustmen
dustoff1445053dustoff
dustpan1043243dustpan
dustrag945363dustrag
dutch114713823du_tch
duty85321453du_t_y
estop74312103_estop
frustum1243953frustum
fuckup1733963fuckup
fustic11910633fustic
fusty115016513fust_y
getup83410263_getup
gust55240703gust__
gusted84316723gusted
gusto65414643gust_o
gusts65722793gust_s
gusty95119573gust_y
hustle93113993hustle
instep838193instep
just115433343just__
justed144215773justed
juster134617013juster
justle133211583justle
justly16307253justly
justs124918263just_s
kultur1034433kultur
letup73712163_letup
lust47442603lust__
lusted74319443lusted
luster64023673luster
lustful1045283lustful
lustra6358893lustra
lustre64011683lustre
lustrum945853lustrum
lusts55022803lust_s
lusty85417573lust_y
lusus54813873lus_us
muktuk1142883muktuk
museum1037703museum
must65145443must__
musted93321073musted
mustee83922103mustee
muster84724523muster
musth105314783must_h
musths11589483musths
musts75527443must_s
musty105620953must_y
oust46747443oust__
ousted73720583ousted
ouster64223733ouster
ousts55225703oust_s
pasteup1134983pasteup
postop10511943postop
pullup1045893pullup
pushups1433653pushups
pustule937683pustule
rust45544913rust__
rusted75020923rusted
rustic8712673rustic
rustle63615413rustle
rusts55026993rust_s
rusty85221053rust_y
scup84822383__scup
setup73915823_setup
situp74414063_situp
soup66232913__soup
step67126293__step
stop66532033__stop
stoup75517073__stoup
stub66221843__stub
stud56220093__stud
stum65526023__stum
stump94616463__stump
stun45623453__stun
stupa74112313__stupa
stupe75217753__stupe
sunup7313053su_nup
sup57041943__s_up
tittup834203tittup
tossup875293tossup
tuneup835203tuneup
tup56037543___tup
turnup835093turnup
tussur6357293tussur
tutu48423173tu_tu_
tutus55214813tu_tus
unstep839223unstep
unstop837473unstop
upstep1035503upstep
usque14137733_usque
usurp7106903_usurp
washup1435323washup
wushu1136993wushu_
xystus16354423xystus

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.373479064.3
2DLD Change Limit1127161655.62620034.8
3Display Results1651650.0632619.0
 (SQL Overall)1786911656.06229477.2
 
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.