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

192 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
bustard1038972(None) 
bastard103012421bastard
bustards11308511bustards
custard10389971custard
mustard10359531mustard
bastards113310312bastards
bastardy14326002bastardy
busbar1038452busbar_
busbars1138152busbars
busted95123152bust_ed
buster84726492buster_
busters94724132busters
bustled104011522bustled
buzzard1844272buzzard
costard104113352costard
custards11338392custards
custardy14314902custardy
dastard9279702dastard
mustards11297882mustards
mustardy14265052mustardy
austere7312993austere
austral73411513austral
bard75648863b___ard
bastardly15264293bastardly
basted95227233bast_ed
baster85333593baster_
basters94930303basters
bayard124411663b_ayard
beard86024963b__eard
bedstand1244333bedstand
bedward1497473bedward
beeyard1335523beeyard
bestead10389123bestead
bested94922763best_ed
bestiary1344813bestiary
bestir8311163bestir_
bestirs9311133bestirs
bestrid1039973bestrid
bestud9439303best_ud
beswarm1445783beswarm
bistate9313823bistate
bister84922763bister_
bistered112913333bistered
bisters93922613bisters
bistort91216523bistort
bistre83815023bist_re
bistred103311853bistred
bistro8339943bist_ro
bluster94215313bluster_
blustered12157263blustered
blusters104413893blusters
blustery13368003blustery
board85523003b__oard
boatyard1444073boatyard
bollard103210503bollard
bombard1437333bombard
boyard125411283b_oyard
brassard1144683brassard
briard94311293b_riard
bulbar1039583bulbar_
bulwark1645213bulwark
bunted95219183bunt_ed
bunter85020383bunter_
bunters94717123bunters
burd75534263bu___rd
bursar85413253bursar_
bursars94510893bursars
bursary12397583bursary
bursted1039423burst_ed
burster9310293burster_
bursters1038983bursters
bused85624493bus__ed
busgirl1044143busgirl
bushed124822383bus_hed
busher114922203busher_
bushers124018803bushers
bushland1444193bushland
busied95117223bus_ied
busier85219723busier_
busked134917703bus_ked
busker125517833busker_
buskers133414093buskers
busload1044683busload
busman10310253busma_n
bussed94717053bus_sed
bust65947783bust___
bustic101012693bust_ic
bustics11810883bustics
bustier93916153bustier
bustiers103810053bustiers
busting104221793busting
bustle84015483bust_le
bustler94012573bustler
bustlers104210623bustlers
bustles93816323bustles
busts75227693bust__s
busty105621013bust__y
butane8313653bu_tane
butled94818603bu_tled
buttals938503buttals
butted94722063bu_tted
butter84724233butter_
buttered112712623buttered
butters94521723butters
buttery124311193buttery
buzzards1943613buzzards
costar85518613costar_
costards113510793costards
costars94218013costars
dastards10278083dastards
discard11310213discard
dotard839053_dotard
dullard936603dullard
dusted83918373dust_ed
duster74919723duster_
dusters84918363dusters
dustrag945363dustrag
eastward1244993eastward
eustacy1254663eustacy
eustasy1043873eustasy
guard74415543gu__ard
guisard954203guisard
guitar7117443guitar_
guitars8116863guitars
gurnard944773gurnard
gusted84316723gust_ed
husband1345653husband
hussar9317283hussar_
hussars10326983hussars
hustled113210133hustled
instar6310013instar_
instars7411133instars
justed144215773just_ed
juster134617013juster_
justers143815733justers
justled15338093justled
leotard846193leotard
lusted74319443lust_ed
luster64023673luster_
lustered92510603lustered
lusters73921443lusters
lustra6358893lust_ra
lustral7339653lustral
lustre64011683lust_re
lustred8359053lustred
mustang10267933mustang
musted93321073must_ed
muster84724523muster_
mustered112511503mustered
musters94522513musters
ousted73720583oust_ed
ouster64223733ouster_
ousters74122793ousters
outadd837803ou_tadd
outsaid81210923outsaid
outstand938043outstand
outstare81410693outstare
outstared10188423outstared
outstart81611283outstart
outward11811403outward
petard95013803_petard
postcard1346523postcard
restart7320033restart
retard75018933_retard
ritard74812083_ritard
rusted75020923rust_ed
rustled83311323rustled
sard55344243__s_ard
shard96125963__shard
staid66722083__staid
stand65923283__stand
star48037763__star_
stare54440263__stare
stared75429873__stared
stark95425623__stark
stars55836573__stars
start55642313__start
sunward1137653sunward
sustain738773sustain
sward94221463__sward
tuatara745513tuatara
tussar6369543tussar_
tussars7359253tussars
unitard838003unitard
upstand1045343upstand
upstare9158683upstare
upstared11156573upstared
upstart9159753upstart
upward12147163_upward
visard103910123vis_ard
vistaed1138023vistaed
westward1543823westward

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271926.14021828.5
3Display Results1921920.0633047.6
 (SQL Overall)1786911926.60927037.5
 
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.