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

179 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
banshee12121245(None) 
banshees13127861banshees
banshie12129541banshie
banished14189072banished
banisher13169192banisher
banishes131812472banishes
banshies131110662banshies
bashed126225702ba_shed
basher115123812ba_sher
bashes115631392ba_shes
abashed1357663abashed
abashes12510373abashes
ansae55720973_ans_ae
ansate64517863_ansate
answer936893_answer
anthem113410343_anthem
anther93715063_anther
ashed97829773_a_shed
ashen87818673_a_shen
ashes86230613_a_shes
baases85218013baas_es
bached145519893ba_ched
baches135426943ba_ches
backhoe1847153backhoe
bailee84526013ba_ilee
baksheesh2141363baksheesh
bandage11311023bandage
banded105223173ban_ded
bander93928223ban_der
bandied114414303bandied
bandies104124863bandies
bandore10611633bandore
bandshell1563043bandshell
bandsmen1356453bandsmen
bane65250433ban___e
baned85436353ban__ed
banes74945583ban__es
banged104923733ban_ged
banger94423643ban_ger
bangle94018963ban_gle
bangles103617413bangles
banish111416063banish__
banishers14258053banishers
banister10199973banister
banjoes16317313banjoes
banked135021443ban_ked
banker124222733ban_ker
bankside15115653bankside
banned94721343ban_ned
banner84421503ban_ner
bannet84925333ban_net
banquet1839783banquet
bans66555143bans___
banter84825343ban_ter
banties94324763banties
bargee94624453ba_rgee
base64847023ba_s__e
based85331583ba_s_ed
baser74828923ba_s_er
bases75644353ba_s_es
bash915240163ba_sh__
bashaw14349303ba_shaw
bashers124820833ba_shers
basked135218603ba_sked
basket125722913ba_sket
basque17259083ba_sque
basses85428303ba_sses
basset85225383ba_sset
baste74829983ba_s_te
basted95227233ba_sted
baster85333603ba_ster
bastes85330383ba_stes
batched154114243batched
batcher144414853batcher
batches144019613batches
bathe105822883ba_th_e
bathed125518743ba_thed
bather115322513ba_ther
bathes116524833ba_thes
batsmen1146883batsmen
baubee103215993ba_ubee
bawbee132714233ba_wbee
bedsheet1446683bedsheet
benched154713943benched
bencher144113483bencher
benches143918603benches
bendee94121023ben_dee
blanched16308603blanched
blancher15338633blancher
blanches153311603blanches
blushed134411753blushed
blusher124113113blusher
blushes124314823blushes
bolshie1247123bolshie
boshes114721883b_oshes
bouchee143313543bouchee
branched163210453branched
branches153613803branches
brasher124515243brasher
brashes124518463brashes
brushed133811213brushed
brusher123813003brusher
brushes124014663brushes
buckshee1945403buckshee
bunched154312413bunched
bunches144116033bunches
bungee96319773bun_gee
bushed124822383b_ushed
bushel114513943b_ushel
busher114922203b_usher
bushes115226113b_ushes
cashed125124353ca_shed
cashes114729883ca_shes
cashew144311453ca_shew
danishes121710503danishes
dashed115920563da_shed
dasheen1136393da_sheen
dasher104318983da_sher
dashes106124983da_shes
fashed136720253fa_shed
fashes124524023fa_shes
garnishee13185763garnishee
gashed116321973ga_shed
gasher104320373ga_sher
gashes105725153ga_shes
gnashed12317523gnashed
gnashes11419573gnashes
hanse85722793hans__e
hansel95214373hans_el
hanses95022633hans_es
harshen1339283harshen
harsher13310363harsher
hashed136021943ha_shed
hashes125024803ha_shes
kasher134915033ka_sher
lashed105625213la_shed
lasher94824533la_sher
lashes94831003la_shes
mainsheet1445573mainsheet
manatee9317663manatee
manche133515103manch_e
manches143818623manches
manchet143317783manchet
manse75528233mans__e
manses84225513mans_es
marshes123615373marshes
mashed125325043ma_shed
masher114123203ma_sher
mashes115030003ma_shes
mashie11315933ma_shie
menshen1236813menshen
menshes12310453menshes
pansies94521983pansies
panther12611443panther
pashed125923143pa_shed
pashes115828393pa_shes
passee84522023pa_ssee
pensee8417313pens_ee
ranched133113603ranched
rancher123013633rancher
ranches123620113ranches
ranee55438103ran__ee
rasher95024123ra_sher
rashes95330153ra_shes
rushee93818773_rushee
sandshoe1245073sandshoe
sansei63411903sans_ei
sashed105622943sa_shed
sashes94728483sa_shes
snashes105214753snashes
tansies74521243tansies
unshed10313773_unshed
vanished15207763vanished
vanisher14167473vanisher
vanishes141610773vanishes
washed135521503wa_shed
washer124720393wa_sher
washes124425493wa_shes
xanthene1855553xanthene

Search took 9 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.420425454.8
2DLD Change Limit1340271797.67317467.4
3Display Results1791790.0632841.3
 (SQL Overall)1786911798.15621909.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.