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

211 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
gangrel99614(None) 
gangrels1094971gangrels
langrel8107031langrel
angel65019572_ang_el
gambrel1235452gambrel
ganged94619202gang_ed
ganger83721472gang_er
gangers94418602gangers
gangrene1044362gangrene
gangue81310582gangue_
gangues9149752gangues
langrels9106172langrels
mandrel1038682mandrel
mangel94017542mang_el
mongrel1036332mongrel
agree65226033_a_gree
aigret73720023_aigret
angels74416173_ang_els
anger66225883_ang_er
angered93013473_angered
angerly1137773_angerly
angers75222543_angers
angle64528883_angle_
angled84219093_angled
angler74017863_angler
angles74426703_angles
angrier839023_angrier
angrily1137723_angrily
angry9310873_angr_y
antral65719413_antral
antre55224523_antre_
antres65021003_antres
anural65714743_anural
bagel85116793ba_g_el
banged104923733bang_ed
banger94423643bang_er
bangers104020353bangers
bangle94018963bangle_
bangles103617413bangles
barrel84517873ba_rrel
cancel105316683can_cel
cangue91012453cangue_
cangues10611823cangues
cannel84216403can_nel
carrel84718633ca_rrel
danged94819493dang_ed
danger83722833dang_er
dangered11248513dangered
dangers94818213dangers
dangle84119313dangle_
dangled104013153dangled
dangler96912813dangler
dangles93618423dangles
doggrel1033883doggrel
eagre64315323ea_gre_
eagres74014573ea_gres
evangel1134303evang_el
fanged114318233fang_ed
gadget93616183gadg_et
gage65936103ga_g_e_
gaged85522313ga_g_ed
gager74726293ga_g_er
gagers84021333ga_gers
gages74529973ga_g_es
gagged104817153ga_gged
gagger95016513ga_gger
gaggers103413663gaggers
gaggle93412623gaggle_
gaggled11359913gaggled
gaggles103512593gaggles
gagmen103910413ga_gmen
galere73716683galere_
galeres83514343galeres
galore73514873galore_
galores82614343galores
gambrels1334213gambrels
gander84322763gan_der
gandered112211173gandered
ganders93521703ganders
gane55145303gan__e_
ganef96322463gan__ef
ganev95513863gan__ev
gang66031983gang___
ganging103216193ganging
ganglia946613ganglia
ganglial1054663ganglial
ganglier1047603ganglier
gangly113911593gang_ly
gangrened1242733gangrened
gangrenes1145063gangrenes
gangs76222583gang__s
gangsta944513gangsta
gangster10215773gangster
gangway1544233gangway
gannet74321853gan_net
gantlet83616243gantlet
gantries91413793gantries
gantry103810113gantr_y
garget84327273garg_et
gargle84215463gargle_
gargled104210673gargled
gargler93710263gargler
gargles94214893gargles
garnered10247113garnered
garred85217413ga_rred
garret74426563ga_rret
gastral8329553gastral
gastrea847243gastrea
gauge76117903gaug_e_
gauged94713473gaug_ed
gauger84714853gaug_er
gaugers94211713gaugers
gauges85915993gaug_es
gavel95815183ga__vel
general81010943general
genre66016803gen_re_
genres75515623gen_res
genteel836753genteel
gingal81010153ging_al
gingall9117333gingall
gingeli9286153ging_eli
gingely12378213ging_ely
ginger84920033ging_er
gingered11127743gingered
gingerly13315303gingerly
gingers94118643gingers
gingery12368913gingery
gnarl65115573g_nar_l
gnarred9327013gnarred
gomerel1036393gomerel
gonged97115913gong_ed
grange83716203grang_e_
granger93514213grang_er
grangers103011973grangers
granges93516523grang_es
gunnel73411053gun_nel
gunsel7339853gun_sel
handsel11308723handsel
hangared1337573hangared
hanged114222403hang_ed
hanger104023263hang_er
hangers113120813hangers
hangmen1337383hangmen
hangul1049223hang_ul
hansel95214373han_sel
haverel13397153haverel
jangle144416303jangle_
jangled164111563jangled
jangler153811833jangler
jangles154015683jangles
langley1147453langley
langue71012183langue_
langues81211913langues
languet8713693languet
laurel649033la_urel
maigre9309163maigre_
malgre9299303malgre_
mandrels1137313mandrels
mandril1049353mandril
mange84930203mang_e_
mangels103614493mang_els
manger94325013mang_er
mangers103521263mangers
manges94628953mang_es
mangey123614533mang_ey
mangier104114063mangier
mangle93921333mangle_
mangled113615263mangled
mangler103215643mangler
mangles104021463mangles
mangoes104316133mangoes
mangonel1185763mangonel
mantel84317973man_tel
manure8313653manure_
manured1039473manured
manurer938583manurer
manures9313353manures
maugre9308973maugre_
mongrels1135333mongrels
panel76023623pan__el
panged104722343pang_ed
pangen94115923pang_en
pangram1239023pangram
parrel84515983pa_rrel
range64728423rang_e_
ranged84824323rang_ed
ranger73925533rang_er
rangers83621043rangers
ranges73826933rang_es
rangier83714353rangier
sangaree949333sangaree
sanger74524573sang_er
sangers84421943sangers
sangria838113sangria
saurel6511993sa_urel
spandrel1144063spandrel
tanged84622513tang_ed
tangelo837043tang_elo
tangier83013913tangier
tangle74019973tangle_
tangled94214643tangled
tangler83515083tangler
tangles83920053tangles
tangoed9318843tangoed
tangram1038083tangram
tanrec837813tan_rec
wangle103817513wangle_
wangled123312413wangled
wangler113312653wangler
wangles113416933wangles
wastrel1037553wastrel

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 Limit1340272116.84619577.4
3Display Results2112110.0603516.7
 (SQL Overall)1786912117.31224438.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.