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

157 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
bushwa1410514(None) 
bushwah18123981bushwah
bushwas15105611bushwas
bashaw14349302bashaw
bugsha1233822bugsh_a
buqsha2032792buqsh_a
bush96630712bush__
bushed124822382bushed
bushel114513942bushel
busher114922202busher
bushes115226112bushes
bushman1455692bushman
bushwahs19113332bushwahs
bushy135416682bush_y
cushaw14386982cushaw
shwa106014962__shwa
babushka1941063babushka
bash915240163bash__
bashaws15347713bashaws
bashed126225703bashed
basher115123813basher
bashes115631393bashes
bishop1336943bishop
blush105115313blush__
blushed134411753blushed
blusher124113113blusher
blushes124314823blushes
bohea105013733b_ohea
bosh96328973bosh__
boshes114721883boshes
brahma1336193brahma
brush105917473brush__
brushed133811213brushed
brusher123813003brusher
brushes124014663brushes
brushup1443513brushup
brushy14468263brush_y
bubba84311803bu_bba
buckra1436753buckra
buddha1333173buddha
bugshas1334513bugshas
buhl95518223bu_h_l
buhls105111803bu_hls
buhr95315383bu_h_r
buhrs104811243bu_hrs
bulla74620563bu_lla
buna64730723bu__na
bunya103810093bu_nya
buqshas2143573buqshas
bura66139533bu__ra
burka114617693bu_rka
burqa165013093bu_rqa
bursa74921523bu_rsa
bursera936763bursera
bus56950973bus___
busbar1038453busbar
busboy13307443busboy
busby126113293bus_by
bused85624493bus_ed
buses75936013bus_es
bushels124110713bushels
bushers124018803bushers
bushgoat1443443bushgoat
bushido1344453bushido
bushier123712813bushier
bushily15268893bushily
bushing134018583bushing
bushland1444193bushland
bushmen1436303bushmen
bushpig1542573bushpig
bushtit1245963bushtit
bushwhack2651343bushwhack
busied95117223busied
busier85219723busier
busies85525263busies
busily112211503busily
busing96420593busing
busk105429223bus__k
busked134917703busked
busker125517833busker
buskin123811493buskin
busks115521373bus_ks
busload1044683busload
busman10310253busman
busmen1039893busmen
buss65134913bus__s
bussed94717053bussed
busses85023383busses
bust65947783bus__t
busted95123153busted
buster84726493buster
bustic101012693bustic
bustle84015483bustle
busts75227693bus_ts
busty105621013bus_ty
busy94727173bus__y
cashaw14439793cashaw
cumshaw1742303cumshaw
cushat113513693cushat
cushaws15356293cushaws
cushy134412323cush_y
fishway1943813fishway
fusuma1134503fusuma
gush85424003gush__
gushed114816243gushed
gusher104115773gusher
gushes104719033gushes
gushy125213123gush_y
hush105224113hush__
hushed134416673hushed
hushes124718593hushes
kasha124710723kash_a
kishka1232963kishka
lush75327693lush__
lushed104218723lushed
lusher93818763lusher
lushes94022743lushes
lushly12247343lushly
lustra6358893lustra
musca9311763mus_ca
mush94929123mush__
mushed124420843mushed
musher113820573musher
mushes114124563mushes
mushy135316633mush_y
nucha10229793nuch_a
pasha105417183pash_a
pesewa1135543pesewa
pshaw13447513_pshaw
push95526623push__
pushed125017463pushed
pusher114318283pusher
pushes114621663pushes
pushup1335273pushup
pushy134614353push_y
rush76628183rush__
rushed104419863rushed
rushee93818773rushee
rusher94019653rusher
rushes94724363rushes
rushy115414813rush_y
schwa13426843_schwa
sha69837783__sh_a
shaw108132553__shaw
shea76031573__shea
shwas116415103__shwas
sushi8310493sush_i
sushis9311183sushis
tush74523903tush__
tushed104615893tushed
tushes94319473tushes
tushie939723tushie
tushy114212993tush_y
usher84517763_usher
usnea539393_usnea
wisha114910853wish_a
wushu1136993wush_u

Search took 6 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 Limit1127161574.85623211.7
3Display Results1571570.0463413.0
 (SQL Overall)1786911575.27833855.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.