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

330 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
wushu113699(None) 
bush96630712bush_
bushy135416682bushy
cushy134412322cushy
gush85424002gush_
gushy125213122gushy
hush105224112hush_
lush75327692lush_
mush94929122mush_
mushy135316632mushy
push95526622push_
pushup1335272pushup
pushy134614352pushy
rush76628182rush_
rushy115414812rushy
sushi8310492sushi
tush74523902tush_
tushy114212992tushy
wash106033812wash_
washup1435322washup
washy145911842washy
wish107228732wish_
wisha114910852wisha
wuss75219332wus_s
wussy115810342wussy
ash67944603_ash_
ashy107717353_ashy
aught95120703aught
awash116613163awash_
bash915240163bash_
blush105115313blush_
bosh96328973bosh_
brush105917473brush_
brushup1443513brushup
brushy14468263brushy
bubu85022673bu_bu
bugsha1233823bugsha
buhl95518223bu_hl
buhr95315383bu_hr
buqsha2032793buqsha
bus56950973bus__
busby126113293busby
bused85624493bused
buses75936013buses
bushed124822383bushed
bushel114513943bushel
busher114922203busher
bushes115226113bushes
bushwa14105143bushwa
busk105429223bus_k
busks115521373busks
buss65134913bus_s
bust65947783bus_t
busts75227693busts
busty105621013busty
busy94727173bus_y
cash96636283cash_
cosh96127623cosh_
crush106815993crush_
cuish10313173cuish_
cuscus1038113cuscus
cusec94614903cusec
cushat113513693cushat
cushaw14386983cushaw
cusk105521633cus_k
cusks114916053cusks
cusp86021063cus_p
cusps94913673cusps
cuss65430613cus_s
cusso74912293cusso
dash87031633dash_
dashi95013113dashi
dashy125612383dashy
dish86328333dish_
dishy125712353dishy
duchy144310873duchy
duh77930383du_h_
dusk95724153dus_k
dusks105317253dusks
dusky135213043dusky
dust57142533dus_t
dusts65923563dusts
dustup935363dustup
dusty96018323dusty
fash107232293fash_
fichu134810663fichu
fish106926273fish_
fishy146011663fishy
flush115116073flush_
fugu85419863fu_gu
fuse76429993fus_e
fused94820443fused
fusee86224583fusee
fusel85218493fusel
fuses85628423fuses
fusil84715323fusil
fuss76027933fus_s
fussy115613953fussy
fusty115016513fusty
gash86833023gash_
gosh86123423gosh_
gursh94512333gursh_
guru54623913gu_ru
gushed114816243gushed
gusher104115773gusher
gushes104719033gushes
gussy95314323gussy
gust55240703gus_t
gusto65414643gusto
gusts65722793gusts
gusty95119573gusty
hash106936503hash_
huh96432013hu_h_
hunh106323733hunh_
hushed134416673hushed
hushes124718593hushes
hushful1644333hushful
husk116021953hus_k
husks125015453husks
husky156112563husky
hussy116812763hussy
jehu145614863_jehu
josh145117613josh_
juju103612123ju_ju
juku154414853ju_ku
jus106930223jus__
just115433343jus_t
justs124918263justs
kasha124710723kasha
kudu95815423ku_du
kudzu19495783kudzu
kuru85521803ku_ru
kusso9398033kusso
lash76539653lash_
luau44824163lu_au
lulu44122883lu_lu
lushed104218723lushed
lusher93818763lusher
lushes94022743lushes
lushly12247343lushly
lust47442603lus_t
lusts55022803lusts
lusty85417573lusty
lusus54813873lusus
mash96039393mash_
mashy136016503mashy
mesh96823003mesh_
meshy135612783meshy
mosh95227603mosh_
much115224033much_
mucho125013443mucho
mumu86022063mu_mu
mus55946753mus__
musca9311763musca
muse67136033mus_e
mused85524583mused
muser76024123muser
muses75134303muses
museum1037703museum
mushed124420843mushed
musher113820573musher
mushes114124563mushes
music94316403music
musk104526193mus_k
musks116119643musks
musky144715293musky
muss64933763mus_s
mussy104117643mussy
must65145443mus_t
musth105314783musth
musths11589483musths
musts75527443musts
musty105620953musty
nosh76223543nosh_
nucha10229793nucha
nus37939393nus__
ouch95724633ouch_
ought95221533ought
ouph95618373ouph_
ouphe104413263ouphe
ouphs104311273ouphs
ousel55222403ousel
oust46747443ous_t
ousts55225703ousts
pash95638133pash_
pasha105417183pasha
pish96127913pish_
plush105614713plush_
plushy14406973plushy
posh95427323posh_
prahu105013973prahu
pugh106619233pugh_
pupu87620713pu_pu
pus55547843pus__
puses75532203puses
pushed125017463pushed
pusher114318283pusher
pushes114621663pushes
pushful1544493pushful
pushups1433653pushups
puss64830133pus_s
pussy105614843pussy
quash174512163quash_
quipu164811643quipu
qursh174110843qursh_
rash76039933rash_
resh76523453resh_
rishi8311253rishi
roshi8310753roshi
ruche104216763ruche
ruse45938933rus_e
ruses56136583ruses
rushed104419863rushed
rushee93818773rushee
rusher94019653rusher
rushes94724363rushes
rusk85823313rus_k
rusks95816193rusks
rust45544913rus_t
rusts55026993rusts
rusty85221053rusty
ruth76825993ruth_
ruths85714643ruths
sadhu9459963sadhu
samshu11134623samshu
sash77235303sash_
sau36356573__sau
sh56828523__sh_
sha69837783__sha
she66837693__she
shh97121073__shh
shul75823153__shul
shun75122773__shun
shush113812543shush_
shut76137583__shut
shy96728193__shy
slush85316573slush_
slushy12417223slushy
smush104410583smush_
sou37853693__sou
such96424813such_
sugh86423443sugh_
sughs95313323sughs
sulu45128423su_lu
sushis9311183sushis
suss45229303sus_s
swash116316753swash_
swish115114823swish_
swishy15365843swishy
tosh74826813tosh_
tuchun1145443tuchun
tusche1136783tusche
tushed104615893tushed
tushes94319473tushes
tushie939723tushie
tusk85621633tus_k
tusks94915533tusks
tussur6357293tussur
tutu48423173tu_tu
ugh76520683_ugh_
ughs85410973_ughs
uh57429853_u_h_
ulu36028703_u_lu
unau43924153_unau
unshut939013unshut
us26937433_us__
use36835163_us_e
used55722823_used
user45023003_user
uses44931113_uses
usher84517763_usher
usque14137733_usque
vugh117115723vugh_
vughs12678743vughs
was68767563was__
washed135521503washed
washer124720393washer
washes124425493washes
washout13410133washout
washtub1542463washtub
washups1534683washups
wasp95626853was_p
wasps106714693wasps
waspy135410993waspy
wast75655853was_t
waste86125053waste
wasts87433673wasts
waucht14399413waucht
waugh125411683waugh_
waught133811043waught
wecht13415443wecht
welsh113110363welsh_
west75748083wes_t
wests85727003wests
wha96422073w__ha
whish144512923whish_
whisht154510813whisht
who95526773w__ho
whup125714163w__hup
why126920013w__hy
wich125724743wich_
wight123725573wight
wis66552333wis__
wise75737343wis_e
wised95123343wised
wiser85522803wiser
wises85633193wises
wished134417513wished
wisher123617063wisher
wishes124920953wishes
wishful1664503wishful
wisp97124073wis_p
wisps105214183wisps
wispy137210973wispy
wiss75630543wis_s
wist78049293wis_t
wists86728523wists
with105730473with_
withe115220233withe
withy144813763withy
woosh113710733woosh_
wos66953533wos__
wost76544363wos_t
wud76227153wu__d
wurst85122993wurst
wursts95211163wursts
wusses93314893wusses
wuther124511613wuther
wych154011883wych_
yuch125818533yuch_

Search took 5 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 Filter178691836670.1101624463.6
2DLD Change Limit836673304.00020916.8
3Display Results3303300.0933548.4
 (SQL Overall)1786913304.20342515.1
 
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.