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

174 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
banisters1118947(None) 
banishers14258051banishers
banister10199971banister_
bannisters1244321bannisters
canisters112310191canisters
ganisters10248311ganisters
baiters94619302ba_i_ters
balusters1136642balusters
banisher13169182banisher_
banishes131812462banishe_s
banistered1394622banistered
bannister1155372bannister_
banters94623112ban__ters
barristers1244722barristers
basters94930302ba__sters
batistes1039712batiste_s
bisters93922612b__isters
blisters104015082b_listers
canistels11205392canistels
canister101710852canister_
cannisters1245012cannisters
gangsters11205732gangsters
ganister9178992ganister_
gannisters1153842gannisters
lamisters1157122lamisters
magisters1235802magisters
ministers1139622ministers
vanishers15186612vanishers
waisters113811522wa_isters
animaters11129973_animaters
aniseeds944393_aniseeds
anises64826693_anis_e_s
anointers937003_anointers
answers1037043_an_swers
assisters936353assisters
asters65631603_a__sters
bailers94221353ba_i_lers
baiter84422553ba_i_ter_
balisaurs1143093balisaurs
ballasters1245093ballasters
balloters1157673balloters
baluster1037053baluster_
bandagers1335883bandagers
banders104324563ban__ders
bandmasters1684183bandmasters
bangers104020353ban__gers
banished14189063banishe_d
bankers133919093ban__kers
banners94018713ban__ners
banqueters2143143banqueters
banshees13127863ban_shees
banter84825333ban__ter_
banterers112410003banterers
baptistery1742173baptistery
baristas1039723barist_as
barites94322333bari_te_s
barraters1138043barraters
barrister1145733barrister_
barters94223033ba__rters
bashers124820833ba__shers
basifiers1445203basifiers
baster85333593ba__ster_
bastes85330383ba__ste_s
batiste939743batiste__
batters94626013ba__tters
bimesters1336343bimesters
bister84922763b__ister_
bistres94017213b__istres
biters83925243b__i_ters
bitters94920363b__itters
blandishers1743003blandishers
blasters104116143b_lasters
blister94415313b_lister_
blistery13418713b_listery
blusters104413893b_lusters
boasters103915663b_oasters
bolsters103712453b_olsters
boosters104013443b_oosters
brainstems1441933brainstems
bruisers10307953bruis_ers
bruiters10329143brui_ters
bunters94717123bun__ters
burnishers1543703burnishers
bursters1038983b_ursters
busters94724133b__usters
cadasters1236833cadasters
canistel10187253caniste_l
cannister1155723cannister_
canters94827733can__ters
casters94729903ca__sters
cloisters1137433cloisters
dabsters1137053da_bsters
danishes121710493danishe_s
demisters1249203demisters
easters75125683ea__sters
enlisters937113enlisters
fainters11349693fa_inters
filisters1237003filisters
finishers1545353finishers
gagsters10317083ga_gsters
gaiters83516543ga_i_ters
gamesters1236733gamesters
gangster10215773gangster_
gannister1054173gannister_
garnishers14174863garnishers
gasters85624293ga__sters
glisters93912603_glisters
gristers94013403_gristers
hamsters13710423ha_msters
heisters113413133_heisters
hoisters113513483_hoisters
igniters9126233igni_ters
insisters997653insisters
janitors1536853jani_tors
kaisers11369273ka_is_ers
keisters123212043_keisters
klisters123910483_klisters
knitters12336623_knitters
lamister1037653lamister_
lamsters1099753la_msters
lasters75627693la__sters
lavishers1564643lavishers
leisters83312823_leisters
listers74026533__listers
magister1136283magister_
maltsters1135193maltsters
manifesters1652753manifesters
masters94628923ma__sters
meisters103313843_meisters
minister10410363minister_
minsters103813923min_sters
misters93927513__misters
monsters103314553mon_sters
munsters104010553mun_sters
nesters74422793__nesters
niters64624213__ni_ters
painters103013023pa_inters
palmisters1444673palmisters
paniers94717333pani__ers
pasters94531733pa__sters
pavisers13387443pavis_ers
pensters103012123pen_sters
pinasters1136823pinasters
plaisters1137813plaisters
planishers1584773planishers
pranksters1653283pranksters
punishers1434973punishers
punsters103310583pun_sters
raisers73617393ra_is_ers
ranters73323643ran__ters
rasters74629023ra__sters
ravishers1564783ravishers
registers1038893registers
resisters9310453resisters
roisters83615553_roisters
sinister838583sinister_
sisters73721593__sisters
snifters11318613_snifters
songsters1046113songsters
spinsters1136613spinsters
tanistry1144543tanist_ry
tanists7313653tanist__s
tapsters10318803ta_psters
tasters74225643ta__sters
twisters11268173_twisters
uniters73814173_uni_ters
vanisher14167453vanisher_
vanishes141610753vanishe_s
varistors1246533varistors
varnishers16174343varnishers
waister103812383wa_ister_
waiters104218623wa_i_ters
wanters104420093wan__ters
wasters104026593wa__sters

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411747.67319372.0
3Display Results1741740.0762289.5
 (SQL Overall)1786911748.17221866.3
 
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.