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

168 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
banisher1316918(None) 
banished14189061banished
banishers14258051banishers
banishes131812461banishes
banister10199971banister
vanisher14167451vanisher
banish111416042banish__
banisters11189472banisters
bannister1155372bannister
banshee121212452ban_shee
basher115123812ba__sher
blandisher1643462blandisher
burnisher1444822burnisher
canister101710852canister
danishes121710492danishes
finisher1436302finisher
ganister9178992ganister
garnisher13195852garnisher
lavisher1445082lavisher
planisher1495852planisher
punisher1335772punisher
ravisher1465462ravisher
vanished15207742vanished
vanishers15186612vanishers
vanishes141610752vanishes
varnisher15195402varnisher
abolisher1443723abolisher
anise55129703_anis_e_
aniseed839403_aniseed
anises64826693_anis_es
another10289153_another
answer936893_an_swer
anther93715063_an_ther
antsier7410773_antsier
babiche1644573babiche_
babiches1735253babiches
babier103515573babi__er
bailer85425253ba_i_ler
baiter84422553ba_i_ter
balisaur1043263balisaur
ballsier1036523ballsier
baluster1037053baluster
bandager1237703bandager
bander93928223ban__der
bandshell1563043bandshell
bandsmen1356453bandsmen
banger94423633ban__ger
banishing1537143banishing
banishment1775973banishment
banistered1394623banistered
banker124222733ban__ker
banner84421503ban__ner
bannisters1244323bannisters
banshees13127863ban_shees
banshie12129543ban_shie
banshies131110663ban_shies
banter84825333ban__ter
banterer102811773banterer
barnier93213673barni__er
barrister1145733barrister
baser74828923ba__s_er
bashed126225703ba__shed
bashers124820833ba__shers
bashes115631393ba__shes
basifier1337313basifier
baster85333593ba__ster
batcher144414853ba_tcher
batfishes1746583batfishes
bather115322513ba__ther
batiste939743batiste_
batistes1039713batistes
bencher144113483ben_cher
bister84922763b__ister
blancher15338633blan_cher
blandished1743333blandished
blandishers1743003blandishers
blandishes1644613blandishes
blemisher1663653blemisher
blister94415313b_lister
blither124812173b_lither
blusher124113113b_lusher
bonier84321993boni__er
brandished1744003brandished
brandishes1645893brandishes
brasher124515243b_rasher
brisker134210293b_risker
bruiser9349573bruis_er
brusher123813003b_rusher
burnished1544923burnished
burnishers1543703burnishers
burnishes1436643burnishes
busher114922203b__usher
canistel10187253canistel
canisters112310193canisters
cannister1155723cannister
danish101513793danish__
dasher104318983da__sher
evanished1644323evanished
evanishes1545603evanishes
famished1766023famished
famishes1658283famishes
finished1536483finished
finishers1545353finishers
finishes1438983finishes
fisher124917143__fisher
furnisher1544523furnisher
gangster10215773gangster
ganisters10248313ganisters
gannister1054173gannister
garnished14196143garnished
garnishee13185763garnishee
garnishers14174863garnishers
garnishes13198813garnishes
gasher104320373ga__sher
harsher13310363ha_rsher
kaiser103610373ka_is_er
kasher134915033ka__sher
knishes1438263_knishes
lamister1037653lamister
languisher1443073languisher
lasher94824533la__sher
lavished1555133lavished
lavishers1564643lavishers
lavishes1457403lavishes
magister1136283magister
marishes13512553marishes
masher114123203ma__sher
minished1437873minished
minishes13310583minishes
minister10410363minister
monished1438133monished
monishes13311483monishes
nigher103612753__nigher
nosher94616363__nosher
panfishes1737593panfishes
panier84425503pani__er
panther12611443pan_ther
parishes13314753parishes
paviser12489093pavis_er
pisher114317753__pisher
planished1566123planished
planishers1584773planishers
planishes14138523planishes
polisher1388073polisher
punished1436043punished
punishers1434973punishers
punishes1338113punishes
radishes1269463radishes
raiser66620103ra_is_er
rancher123013633ran_cher
rasher95024123ra__sher
ravished1555713ravished
ravishers1564783ravishers
ravishes1478043ravishes
sinister838583sinister
swisher13369523_swisher
tarnished13196063tarnished
tarnishes12188893tarnishes
vanish121513213vanish__
vanquisher2552133vanquisher
varnished16195603varnished
varnishers16174343varnishers
varnishes15207913varnishes
waister103812383wa_ister
wanier93920683wani__er
washer124720393wa__sher
wisher123617063__wisher
zanier154314713zani__er

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621688.07618098.3
3Display Results1681680.0632666.7
 (SQL Overall)1786911688.29521542.0
 
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.