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

186 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
custard1038997(None) 
bustard10389721bustard
costard104113351costard
custards11338391custards
custardy14314901custardy
mustard10359531mustard
bastard103012422bastard
bustards11308512bustards
costar85518612costar_
costards113510792costards
costars94218012costars
dastard9279702dastard
mustards11297882mustards
mustardy14265052mustardy
austere7312993austere
austral73411513austral
bastards113310313bastards
bastardy14326003bastardy
busbar1038453busbar_
busbars1138153busbars
busted95123153bust_ed
buster84726493buster_
busters94724133busters
bustled104011513bustled
buzzard1844273buzzard
cabstand1344413cabstand
canard9314763c_anard
card710245873c___ard
cascara1138313cascara
caster85232573caster_
casters94729903casters
castled104311513castled
castor84418533castor_
castors94919443castors
centare93113703centare
cesta75419483cesta__
cestas85018543cesta_s
cestoid104011673cestoid
chard116124743c__hard
cisted95217523cist_ed
cistern93310703cistern
cluster94013333cluster_
clustered12186613clustered
clusters102912403clusters
clustery13317113clustery
coastward1543553coastward
collard103712923collard
costa75523733costa__
costae85319683costa_e
costal85419513costa_l
costarred1244703costarred
costate94019273costate
costed95623113cost_ed
coster84331293coster_
costers94128333costers
costmary1545053costmary
cottar84613813cottar_
cottars94412243cottars
courtyard1542193courtyard
coward12411673c_oward
crustal939023crusta_l
crusted103712753crust_ed
cuatro838433cuat_ro
cuesta838513cuesta__
cuestas957933cuesta_s
culture939393culture
cultured1137233cultured
cupboard1544253cupboard
curara83712203cu_rara
curare84916953cu_rare
curari84414403cu_rari
curated104717583curated
curd77634983cu___rd
curtail9299663curtail
curtain9319793curtain
curtal83914543curta_l
curtals93111623curtals
curtate9312643curtate
curter85320083curter_
cushat113513693cusha_t
cushats12288273cushats
cushaw14386983cusha_w
cushaws15356293cushaws
cuspal1037883cuspa_l
cuspate1138233cuspate
cuspated1335913cuspated
cusped114312043cus_ped
cuspid11429213cus_pid
cussed94917123cus_sed
cusser86016093cusser_
cussers94213403cussers
cussword1443233cussword
custody1334093custody
custom104010273cust_om
customary1643513customary
customs11348263customs
custos84014313cust_os
cuter74728233cu_ter_
cuttage10318343cuttage
cutter84521003cutter_
cutters94218963cutters
cuttled10319933cuttled
cystoid13309213cystoid
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
staid66722073__staid
stand65923283__stand
star48037763__star_
stare54440263__stare
stared75429873__stared
stark95425623__stark
stars55836573__stars
start55642313__start
sunward1137653sunward
sustain738763sustain
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.1561145455.1
2DLD Change Limit1340271866.42020876.5
3Display Results1861860.0632952.4
 (SQL Overall)1786911866.63926915.3
 
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.