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

227 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
danishes12171049(None) 
banishes131812461banishes
vanishes141610751vanishes
anises64826692_anis_es
banished14189062banished
banisher13169182banisher
banishers14258052banishers
daises74318982da_is_es
daisies84217092da_isies
danish101513792danish__
dashes106124982da__shes
dishes104622652d__ishes
evanishes1545602evanishes
famishes1658282famishes
finishes1438982finishes
garnishes13198812garnishes
knishes1438262_knishes
lavishes1457402lavishes
marishes13512552marishes
minishes13310582minishes
monishes13311482monishes
panfishes1737592panfishes
parishes13314752parishes
planishes14138522planishes
punishes1338112punishes
radishes1269462radishes
ravishes1478042ravishes
tarnishes12188892tarnishes
vanished15207742vanished
vanisher14167452vanisher
vanishers15186612vanishers
varnishes15207912varnishes
abashes12510373_abashes
admonishes1643493admonishes
adonises92611433adonis_es
advisees12154133advisees
advises11138973advis_es
aisles64721143_a_isles
anguishes1345093_anguishes
animes84719593_ani_mes
anise55129703_anis_e_
aniseed839403_aniseed
aniseeds944393_aniseeds
anisoles81010123_anisoles
ankushes1544583_ankushes
anuses66218773_anus_es
arises65233803_aris_es
ashes86230613_a__shes
axises134413993_axis_es
babiches1735253babiches
banish111416043banish__
banister10199973banister
banisters11189473banisters
banshee121212453ban_shee
banshees13127863ban_shees
banshies131110663ban_shies
bashes115631393ba__shes
batfishes1746583batfishes
batistes1039713batistes
blandishes1644613blandishes
brandishes1645893brandishes
burnishes1436643burnishes
calashes13310533calashes
caliches153812263caliches
camises114218463camis_es
canines93724033cani_nes
canistel10187253canistel
canistels11205393canistels
canister101710853canister
canisters112310193canisters
canities101519263canities
cashes114729883ca__shes
catfishes1746303catfishes
cuishes122810823_cuishes
dacites101114593daci_tes
dailies84219263da_ilies
dainties9312403dainties
dairies84217733da_iries
daisied93410013da_isied
damnifies1545543damnifies
dances95120653dan__ces
dandies94121443dan_dies
dandifies1476893dandifies
dandles94218533dan_dles
dangles93618423dan_gles
danios7314603dani__os
darioles9710693darioles
dashed115920563da__shed
dasher104318983da__sher
dashers115016863da__shers
dashis104414393da__shis
dassies84418663da_ssies
datives11310073dati_ves
davies105020513davi__es
daysides1335963daysides
dealfishes1744193dealfishes
deashes113313903d_eashes
dehisces1464713dehisces
demises103719563demis_es
denies74729643deni__es
dervishes1644933dervishes
devisees12358283devisees
devises114116763devis_es
diminishes1644973diminishes
dished114318713d__ished
dismes95617673d__ismes
disses75225963d__isses
dogfishes1745083dogfishes
dunches133312583dun_ches
dunites8313593duni_tes
enisles72312603_enisles
evanished1644323evanished
famished1766023famished
fashes124524023fa__shes
fetishes1437153fetishes
finfishes1846043finfishes
finises10312903finis_es
finished1536483finished
finisher1436303finisher
finishers1545353finishers
fishes125221343__fishes
furnishes1536233furnishes
galoshes1236893galoshes
gamashes1456943gamashes
ganaches1437413ganaches
ganister9178993ganister
ganisters10248313ganisters
garfishes16167083garfishes
garnished14196143garnished
garnishee13185763garnishee
garnishees14184173garnishees
garnisher13195853garnisher
garnishers14174863garnishers
gashes105725153ga__shes
gnashes11419573_gnashes
hagfishes1945153hagfishes
hanses95022633han_s_es
hashes125024803ha__shes
hashishes1444393hashishes
ionises72916433ionis_es
kaddishes1844093kaddishes
kyanises15206393kyanis_es
languishes1444243languishes
lapises93513463lapis_es
lashes94831003la__shes
lavashes1445573lavashes
lavished1555133lavished
lavisher1445083lavisher
lavishers1564643lavishers
lavishest1554883lavishest
manches143818623man_ches
manilles102312603manilles
maniples12269423maniples
manses84225513man_s_es
mantises10317923mantis_es
marshes123615373ma_rshes
mashes115030003ma__shes
mavises122812993mavis_es
menshes12310443men_shes
minished1437873minished
monished1438133monished
nanisms938833nanis_ms
niches114419143__niches
noshes96618233__noshes
oarfishes15156953oarfishes
ornithes1136423ornithes
painches1588913painches
panaches15310283panaches
panicles121010113panicles
panoches1548123panoches
pansies94521983pan_sies
parises94827183paris_es
pashes115828393pa__shes
pavises125315493pavis_es
pavisses13397103pavisses
penises9318193penis_es
perishes13313753perishes
pinfishes1746243pinfishes
pishes114722103__pishes
planished1566123planished
planisher1495853planisher
planishers1584773planishers
plenishes1487083plenishes
polishes13711783polishes
punished1436043punished
punisher1335773punisher
punishers1434973punishers
raises64826543ra_is_es
ranches123620113ran_ches
rashes95330153ra__shes
ratfishes1546103ratfishes
ravished1555713ravished
ravisher1465463ravisher
ravishers1564783ravishers
relishes11311953relishes
sandfishes1745543sandfishes
sandshoes1345213sandshoes
sanicles10149943sanicles
sanies63031953sani__es
sanities81219773sanities
sashes94728483sa__shes
sawfishes1845743sawfishes
snashes105214753_snashes
squishes20198393squishes
standishes1445713standishes
stonishes1247363stonishes
sunfishes1547033sunfishes
swishes133411373_swishes
tamises92715973tamis_es
tanists7313653tanis_ts
tansies74521243tan_sies
tapises92914013tapis_es
tarnished13196063tarnished
tundishes1344543tundishes
unwishes14147483unwishes
valises103516263valis_es
vanish121513213vanish__
vanities111414493vanities
vanquishes2542943vanquishes
varnished16195603varnished
varnisher15195403varnisher
varnishers16174343varnishers
wampishes1944303wampishes
washes124425493wa__shes
whishes16309443_whishes
wishes124920953__wishes
zanies153219673zani__es

Search took 8 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 Filter1786911461620.1731032896.0
2DLD Change Limit1461622277.42019698.4
3Display Results2272270.0962364.6
 (SQL Overall)1786912277.68923239.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.