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

131 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
evangel113430(None) 
evangels1243731evangels
angel65019562__angel
evangelic1552882evangelic
mangel94017532_mangel
angels74416173__angels
anger66225873__anger
angle64528873__angle
avenge1087553avenge_
avenged1245503avenged
avenger1135493avenger
avenges1157543avenges
bagel85116793_ba_gel
banged104923723_banged
banger94423633_banger
bangle94018953_bangle
cancel105316683_cancel
cannel84216403_cannel
chancel144011773chancel
change124116753change_
changed144214143changed
changer134215543changer
changes134517583changes
channel123910483channel
clanged114212653clanged
clanger104113493clanger
danged94819483_danged
danger83722823_danger
dangle84119303_dangle
defanged1435433defanged
derange939813derange_
deranged1137693deranged
deranger1037353deranger
deranges1039973deranges
eager65526973e_a_ger
eagle64219483e_a_gle
easel54521113e_a_sel
empanel1145963empan_el
enamel81210113ena_mel
endanger1045853endanger
entangle966253entangle
evacuee12105073evacuee
evade938183eva_de_
evaded1137063eva_ded
evader1036813eva_der
evades1039023eva_des
evangelism16113063evangelism
evangelist14123863evangelist
evangelize2352713evangelize
evanish1337653evanish
evened101010313even_ed
evener91010623even_er
evince1137763evince_
evinced1335403evinced
evinces1237803evinces
fanged114318223_fanged
flange103411973flange_
flanged123810843flanged
flanger113412623flanger
flanges113413273flanges
flannel1035423flannel
ganged94619193_ganged
ganger83721463_ganger
gangrel996143_gangrel
grange83716203grange_
granger93514213granger
granges93516523granges
hanged114222393_hanged
hanger104023253_hanger
hangul1049213_hangul
hansel95214373_hansel
jangle144416293_jangle
langrel8107033_langrel
levanted1245323levanted
levanter1145303levanter
mange84930193_mange_
mangels103614493_mangels
manger94325003_manger
manges94628943_manges
mangey123614523_mangey
mangle93921323_mangle
mantel84317973_mantel
melange1038363melange_
melanges1138613melanges
orange74016323orange_
oranges84215333oranges
orangey11388833orangey
panel76023623_pan_el
panged104722333_panged
pangen94115913_pangen
pranged114512553pranged
range64728413_range_
ranged84824313_ranged
ranger73925523_ranger
ranges73826923_ranges
rehanged1357833rehanged
repanel939963repan_el
revenge1138573revenge_
revenged1337553revenged
revenger1237303revenger
revenges1238983revenges
sanger74524563_sanger
slanged94112853slanged
spancel1147363spancel
spangle1038403spangle
spaniel948923spaniel
stanged94113843stanged
tanged84622493_tanged
tangelo837033_tangelo
tangle74019953_tangle
twanged12387273twanged
twanger11327433twanger
twangle1145803twangle
vagal94613633_va_gal
vakeel1335193_vakeel
vandal103713833_vandal
vane75534693_van_e_
vaned94622423_van_ed
vanes85130973_van_es
vang84926043_vang__
vangs96319583_vang_s
vanmen1138403_vanmen
vanned104614483_vanned
vanner94215843_vanner
venge95117993_venge_
venged114011993_venged
venges104015153_venges
wangle103817503_wangle
whanged15447613whanged
whangee14268613whangee
wrangle1137383wrangle

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271315.79623124.1
3Display Results1311310.0462847.8
 (SQL Overall)1786911316.24828599.7
 
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.