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

130 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
banshees1312786(None) 
banshee121212451banshee_
banshies131110661banshies
baksheesh2141362baksheesh
banishers14258052banishers
banishes131812462banish_es
banshie12129542banshie_
bashers124820832ba_shers
bashes115631392ba_sh_es
abashes12510373abash_es
answers1037043_answers
anthems12309423_anthems
anthers103715203_anthers
antheses11311473_antheses
ashes86230613_a_sh_es
baases85218013baas__es
baches135426943ba_ch_es
backhoes1938543backhoes
bailees93914383ba_ilees
bandages12310633bandages
banders104324563ban_ders
bandies104124863ban_dies
bandores11311603bandores
bandshell1563043bandshell
bandshells1672373bandshells
banes74945583ban___es
bangers104020353ban_gers
bangles103617413ban_gles
banished14189063banish_ed
banisher13169183banish_er
banisters11189473banisters
banjaxes2443393banjaxes
banjoes16317313ban_joes
bankers133919093ban_kers
banksides16104853banksides
banners94018713ban_ners
bannets94013843ban_nets
banquets1935433banquets
banters94623113ban_ters
banties94324763ban_ties
bargees105415873ba_rgees
bases75644353ba_s__es
bashaws15347713ba_shaws
bashed126225703ba_sh_ed
basher115123813ba_sh_er
baskets135111833ba_skets
basques18248673ba_sques
basses85428303ba_s_ses
bassets96414823ba_ssets
bassness1096743bassness
basters94930303ba_sters
bastes85330383ba_s_tes
batchers153613273batchers
batches144019613batch_es
bathers124720363ba_thers
bathes116524833ba_th_es
baubees11348713ba_ubees
bawbees14337243ba_wbees
bedsheet1446683bedsheet
bedsheets1542943bedsheets
benchers153611013benchers
benches143918603bench_es
bendees103913863ben_dees
blanchers16307433blanchers
blanches153311603blanch_es
blushers133911293blushers
blushes124314823blush_es
bolshies1338693bolshies
boshes114721883b_osh_es
bouchees15339533bouchees
branches153613803branch_es
brashes124518463brash_es
brushers134210573brushers
brushes124014663brush_es
buckshees2044083buckshees
bunches144116033bunch_es
bungees104513103bun_gees
bushels124110713b_ushels
bushers124018803b_ushers
bushes115226113b_ush_es
cashes114729883ca_sh_es
cashews15428603ca_shews
danishes121710493danish_es
dasheen1136393da_sheen
dasheens1244693da_sheens
dashers115016863da_shers
dashes106124983da_sh_es
fashes124524023fa_sh_es
garnishees14184173garnishees
gashes105725153ga_sh_es
gnashes11419573gnash_es
hansels104011653hans_els
hanses95022633hans__es
harshens1437603harshens
hasheesh1342593ha_sheesh
hashes125024803ha_sh_es
kashers143914023ka_shers
lashers104121833la_shers
lashes94831003la_sh_es
mainsheet1445573mainsheet
mainsheets1542893mainsheets
manatees10310423manatees
manches143818623manch_es
manchets15269573manchets
manses84225513mans__es
marshes123615373marsh_es
mashers124621053ma_shers
mashes115030003ma_sh_es
mashies12318253ma_shies
menshes12310453mensh_es
pansies94521983pans_ies
panthers13510783panthers
pashes115828393pa_sh_es
pensees9311203pens_ees
ranchers133311793ranchers
ranches123620113ranch_es
ranees64623963ran__ees
rashers104020913ra_shers
rashes95330153ra_sh_es
rushees103311953_rushees
sandshoes1345213sandshoes
sanseis73011603sans_eis
sashes94728483sa_sh_es
snashes105214753snash_es
tansies74521243tans_ies
vanishers15186613vanishers
vanishes141610753vanish_es
washers134517523wa_shers
washes124425493wa_sh_es
xanthenes1956353xanthenes

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621306.50322476.1
3Display Results1301300.0433023.3
 (SQL Overall)1786911306.96625651.9
 
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.