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

123 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
banshie1212954(None) 
banshee121212451banshee
banshies131110661banshies
banshees13127862banshees
bolshie1247122bolshie
mashie11315932ma_shie
anomie83215963_anomie
ansae55720973_ans_ae
ansate64517863_ansate
arshin9312173_arshin
ashier94714833_a_shier
bacchic1545813bacchic
bacchii1644543bacchii
backhoe1847153backhoe
baddie104114033ba_ddie
baggie102912193ba_ggie
bailie83818363ba_ilie
bakshish2043743bakshish
banalize191010933banalize
bandage11311023bandage
bandaid11310483bandaid
bandied114414303ban_died
bandies104124863ban_dies
bandit93821133ban_dit
bandore10611633bandore
bane65250433ban___e
bangle94018963ban_gle
bani65334963ban__i_
banish111416063banish__
banished14189073banished
banisher13169193banisher
banishes131812473banishes
banishing1537143banishing
bankit123617043ban_kit
banksia1335943banksia
bankside15115653bankside
bans66555143bans___
banties94324763ban_ties
banzai1737653banzai_
banzais1837163banzais
barbie105018353ba_rbie
barmie103816403ba_rmie
base64847023ba_s__e
bash915240163ba_sh__
bashaw14349303ba_shaw
bashed126225703ba_shed
basher115123813ba_sher
bashes115631393ba_shes
bashing135422583ba_shing
basic96220523ba_s_ic
basil75122273ba_s_il
basin75026923ba_s_in
basis75429863ba_s_is
basque17259083ba_sque
bassi77019323ba_ssi_
baste74829983ba_s_te
bastile9313913ba_stile
bathe105822883ba_th_e
bawtie113812143ba_wtie
beanie83618593bean__ie
beastie92412433beastie
benthic1437473benthic
bhistie1236773bhistie
blastie92411393blastie
bolshies1338693bolshies
bonnie85314853bon_nie
bonsai838463bonsai_
bonspiel1243543bonspiel
branchia15217713branchia
branchiae16186313branchiae
branchier1637133branchier
brashier13389933brashier
brassie93411523brassie
brushier13306973brushier
bunchier1536153bunchier
bushier123712813b_ushier
cannie83819363can_nie
canthi11310973canthi_
cashier123713323ca_shier
conchie143312683conchie
dashi95013113da_shi_
dashier114311183da_shier
dashis104414393da_shis
dassie74615573da_ssie
deanship1446563deanship
donsie7613643dons_ie
falsie93513853fals_ie
gawsie1038463gaws_ie
grushie1135813grushie
gunship1345383gunship
hankie133915713han_kie
hanse85722793hans__e
kinship1645833kinship
lassie64917743la_ssie
macchie1647193macchie
manche133515103manch_e
manse75528233mans__e
marshier1337593marshier
mashies12318253ma_shies
nannie63713223nan_nie
palship1446843palship
pansies94521983pans_ies
pantie84326473pan_tie
pastie85525523pa_stie
sandhi1038193sandhi_
sandhis1139993sandhis
sandshoe1245073sandshoe
sansei63411903sansei_
sanseis73011603sanseis
sonship12108653sonship
sonsie6614863sons_ie
sunshine1147923sunshine
tankship1744903tankship
tansies74521243tans_ies
tassie66017023ta_ssie
tranship13410193tranship
tushie939723_tushie
unship1148033_unship
warship1547843warship
washier133611153wa_shier
xanthic1945863xanthic
xanthin1747043xanthin
xanthine1847253xanthine

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271236.75019855.9
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.20224811.3
 
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.