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

118 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
banishing153714(None) 
vanishing1646301vanishing
bashing135422582ba__shing
blandishing1852902blandishing
brandishing1853362brandishing
burnishing1643912burnishing
evanishing1743862evanishing
famishing1845232famishing
finishing1645842finishing
garnishing1544572garnishing
lavishing1644552lavishing
minishing1547072minishing
monishing1547542monishing
planishing1645322planishing
punishing1545382punishing
ravishing1634982ravishing
tarnishing1445152tarnishing
varnishing1744472varnishing
abashing1466623_abashing
abolishing1644233abolishing
agisting1038243_agisting
anguishing1543733_anguishing
anything1534993_anything
arising83619973_aris_ing
ashing107824093_a__shing
baching156017753ba__ching
backswing2144903backswing
bailing103723523ba_i_ling
baiting103918883ba_i_ting
bakshishing2451773bakshishing
bandaging1436063bandaging
banding114921413ban__ding
bandying15218073ban_dying
banging114019863ban__ging
baning95127833ban___ing
banish111416043banish___
banished14189063banish_ed
banisher13169183banish_er
banishers14258053banishers
banishes131812463banish_es
banishment1775973banishment
banjaxing2642553banjaxing
banking144621353ban__king
bannering12208803bannering
banning103818233ban__ning
banshie12129543ban_shi_e
banshies131110663ban_shies
bantering122414233bantering
bantling112612003ban_tling
baptising1446093baptis_ing
bashings144311243ba__shings
basifying1845073basifying
basing95427663ba__s_ing
basking144718613ba__sking
basting104227203ba__sting
batching163712093ba_tching
bathing134816243ba__thing
batiking1537503bati_king
bekissing1643503bekissing
bemisting1438073bemisting
benching163411343ben_ching
blanching17297093blan_ching
blemishing1843513blemishing
blissing1136873b_lissing
blushing14339333b_lushing
bonefishing2052623bonefishing
botanising1345953botanis_ing
braising113014563brais_ing
branching17289263bran_ching
brisking15329473b_risking
brisling112410843b_risling
bruising11279143bruis_ing
brushing14359963b_rushing
bunching163410703bun_ching
burnishings1751863burnishings
bushing134018583b__ushing
cashing135022553ca__shing
dashing125917893da__shing
dishing124017103__dishing
ebonising1245933ebonis_ing
enisling949633_enisling
faithing1537153fa_ithing
fashing144918793fa__shing
fishing143913863__fishing
furnishing1744013furnishing
gashing125119233ga__shing
gnashing1336423_gnashing
hashing145020163ha__shing
ionising9310223ionis_ing
kyanising1743873kyanis_ing
languishing1653113languishing
lashing114422893la__shing
mashing134422243ma__shing
niching133612433__niching
nighing123410063__nighing
noshing114612773__noshing
panicking1835293panicking
pashing135120513pa__shing
perishing1539533perishing
pishing134314373__pishing
plenishing1644693plenishing
polishing1536923polishing
raising83220533ra_is_ing
ranching141712043ran_ching
relishing13229183relishing
sashing114621473sa__shing
squishing2234953squishing
stonishing1444913stonishing
swishing15277813_swishing
unwishing1635593unwishing
urbanising1344653urbanis_ing
vanishingly2151683vanishingly
vanquishing2752283vanquishing
waisting123615213wa_isting
wampishing2142753wampishing
washing145119283wa__shing
whishing18287183_whishing
wishing144114893__wishing

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 Filter1786911486410.440406115.9
2DLD Change Limit1486411187.42020032.5
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.90622601.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.