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

132 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
evanish133765(None) 
vanish121513211_vanish
banish111416042_banish
danish101513792_danish
evanished1644322evanished
evanishes1545602evanishes
planish12412052planish
revarnish1543932revarnish
varnish13169532_varnish
anis45746463__anis_
anise55129703__anise
apish105116633__apish
beamish14259293beamish
bearish123013273bearish
beauish12268513beauish
blandish1497003blandish
boarish123911913boarish
brainish1338813brainish
brandish1469023brandish
brinish1239963brinish
burnish1238623burnish
clannish1345263clannish
clayish1547943clayish
crankish1736513crankish
cronish12310863cronish
deafish1438533deafish
devilish1546373devilish
donnish11187633donnish
dronish1138913dronish
ebonise939613ebonise
elains64919853elains_
elands74914773elands_
elans55527753elan_s_
elfish1267963e_lfish
elvish1277563e_lvish
english1137953english
enravish1444243enravish
eonism83213533e_onism
etatism9610293etatism
etatist7415033etatist
evades1039023evades_
evading1237283evading
evanesce1363133evanesce
evangel1134303evangel
evanishing1743863evanishing
evasion1036753evasion
evasive1344663evasive
evenest10312103evenest
evening11310223evening
evens84817103even_s_
events94814073events_
famish14311843_famish
feverish1745413feverish
finish124613413_finish
furnish1337383furnish
garish104516923_garish
garnish111610843garnish
goatish1139563goatish
grayish1437813grayish
hennish1336863hennish
hunnish1336163hunnish
jadish17319903_jadish
knavish1743993knavish
knish1238603__knish
kyanise14236143kyanise
latish92416173_latish
lavish124112983_lavish
lemonish1347323lemonish
levants1037723levants_
mannish121710693mannish
marish114319053_marish
melanism1239363melanism
melanist10313053melanist
minish115216303_minish
monish114217593_monish
moonish123311043moonish
nanism8311203_nanism
nunnish1035933nunnish
oafish121311723_oafish
onanism9310133onanism
onanist7314633onanist
orangish1246553orangish
paganish1447773paganish
palish114718273_palish
panfish15229973_panfish
parish115022353_parish
peakish16268873peakish
pianism11611033pianism
pianist9615103pianist
plenish1239943plenish
prankish1737023prankish
punish111411503_punish
radish103516913_radish
rakish134313963_rakish
ranis55235833_ranis_
rankish14510383_rankish
ravish123414033_ravish
rawish123012913_rawish
refinish1447893refinish
slavish1338233slavish
standish1238543standish
stonish10410653stonish
swainish1444753swainish
swinish1347203swinish
tanist6324593_tanist
tannish101610573tannish
tarnish101611873tarnish
tetanise8610203tetanise
toadish1139063toadish
tonish93415903_tonish
tonnish10149093tonnish
tovarish1445123tovarish
townish13167933townish
uranism91112513uranism
valise92917643_valise
vampish1766283_vampish
vanes85130973_vanes_
vangs96319583_vangs_
vanished15207743_vanished
vanisher14167453_vanisher
vanishes141610753_vanishes
vanity12311933_vanity
vanquish2343543_vanquish
vans76236733_van_s_
varnishy17163403_varnishy
veganism1446443veganism
weakish17217173weakish
wearish132310153wearish
wennish1336243wennish
winish124212263_winish
womanish1646823womanish
zanyish2235903_zanyish

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 Limit1340271326.68620045.9
3Display Results1321320.0462869.6
 (SQL Overall)1786911327.13825033.8
 
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.