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

263 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
wrangle113738(None) 
wangle103817501w_angle
wrangled1335591wrangled
wrangler1245471wrangler
wrangles1237461wrangles
angle64528872__angle
bangle94018952_bangle
crankle133610062crankle
cringle103010352cringle
dangle84119302_dangle
draggle1056102draggle
grange83716202grang_e
granule839472granule
jangle144416292_jangle
mangle93921322_mangle
orange74016322orang_e
raggle83712882_raggle
range64728412_rang_e
rankle103414882_rankle
spangle1038402spangle
strangle98411502strangle
tangle74019952_tangle
triangle935532triangle
twangle1145802twangle
waggle113612302w_aggle
wandle105316662w_andle
wangled123312412w_angled
wangler113312652w_angler
wangles113416932w_angles
whangee14268612whangee
wrang94716112wrang__
wranglers1344272wranglers
wrangs104611912wrang_s
wrassle10357172wrassle
wrastle10368992wrastle
wriggle12316212wriggle
wrinkle14296922wrinkle
wrongly1434552wrongly
anele55628833__anele
angel65019563__angel
angled84219083__angled
angler74017863__angler
angles74426703__angles
anglo65215373__anglo
anile54634463__anile
ankle95220253__ankle
anole55330373__anole
arable81821003ara_ble
argle65421563__argle
arrange838683arrang_e
atingle848253atingle
bangles103617413_bangles
beagle93612593bea_gle
brabble10349973brabble
braille939713braille
bramble133710033bramble
brattle9249253brattle
brindle104210103brindle
bungle97116113_bungle
candle94321483_candle
cangue91012443_cangue
cantle84522153_cantle
change124116753chang_e
crackle153611253crackle
cradle93313163cra_dle
crane75331603cran__e
crankled15408153crankled
crankles143510153crankles
crankly16358123crankly
cringe93515483cring_e
cringles11329463cringles
crinkle13359413crinkle
daggle93711903_daggle
dandle84218093_dandle
dangled104013153_dangled
dangler96912813_dangler
dangles93618423_dangles
dangly114212263_dangly
derange939813derang_e
dingle84317073_dingle
dongle83612493_dongle
drabble12238883drabble
dragee84415603dra_gee
draggled1254673draggled
draggles1145963draggles
eagle64219483_ea_gle
embrangle1453293embrangle
entangle966243entangle
evangel1134303evangel
fenagle11197153fenagle
finagle11238313finagle
flange103411973flang_e
fragile1147843fragile
frangible1543753frangible
frankly17315633frankly
frazzle18305223frazzle
fringe104013953fring_e
gaggle93412623_gaggle
gangly113911583_gangly
gangue81310573_gangue
gargle84215463_gargle
grabble12339643grabble
gracile102512603gracile
grackle14338893grackle
grandee93115513grandee
grandly1238743grandly
granger93514213granger
granges93516523granges
granite82017083granite
grannie8310353grannie
granola837913granola
grantee83217133grantee
granules939933granules
grapple12378003grapple
grunge8359583grung_e
gruntle8257053gruntle
haggle113511983_haggle
handle104219293_handle
hantle94318203_hantle
harangue1244103harangue
ingle64120433__ingle
jangled164111563_jangled
jangler153811833_jangler
jangles154015683_jangles
jangly174310603_jangly
jingle143815223_jingle
jungle144012653_jungle
langley1147453_langley
langue71012173_langue
mange84930183_mang_e
mangel94017533_mangel
mangled113615263_mangled
mangler103215643_mangler
mangles104021463_mangles
mantle84420923_mantle
mingle93518783_mingle
octangle1143833octangle
oracle84313293ora_cle
orang65119943orang__
oranges84215333oranges
orangey11388833orangey
orangier947703orangier
orangs74116033orang_s
orangy105111233orang_y
prance104318573pran_ce
prang84820323prang__
pranged114512553pranged
prangs94816233prang_s
prattle9208833prattle
pungle94413573_pungle
rabble103818243_rabble
rackle123917293_rackle
raddle84816173_raddle
raffle123910703_raffle
rage55742353_ra_g_e
ragee65432663_ra_gee
raggee84217603_raggee
raggles93813283_raggles
rale45050563_ra__le
ramble104519973_ramble
rance75028513_ran_ce
ranee55438103_ran_ee
rang56939153_rang__
ranged84824313_ranged
ranger73925523_ranger
ranges73826923_ranges
rangier83714353_rangier
rangy95320383_rang_y
rankled123910653_rankled
rankles113114543_rankles
rankly133910453_rankly
ranula6311813_ranula
rassle63813203_rassle
rattle64717613_rattle
ringlet82818173_ringlet
rundle73214233_rundle
runkle103611543_runkle
shingle117711283shingle
single74520603_single
spangled1236143spangled
spangles1138893spangles
spangly1336473spangly
straggle10359133straggle
strange85416343strang_e
strangled11268983strangled
strangler10369473strangler
strangles103011553strangles
swingle113510563swingle
tangled94214633_tangled
tangler83515073_tangler
tangles83920043_tangles
tangly104413913_tangly
tingle74319063_tingle
trachle12311853trachle
trample11299703trample
trance84718763tran_ce
tranche123312223tranche
trangam1039353trangam
triangled1143943triangled
triangles1035743triangles
trindle83311363trindle
trundle8307873trundle
twangled1364173twangled
twangler1244113twangler
twangles1245743twangles
untangle966323untangle
uranide82212093uranide
uranite72515693uranite
uranyl936293uranyl_
uranyls1034453uranyls
wabble133714843w_abble
waddle114715303w_addle
waffle15369183w_affle
wage84834083w_a_g_e
waggled13389363w_aggled
waggles123812003w_aggles
waggly14347293w_aggly
wale74546433w_a__le
wamble134415753w_amble
wane76344713w_an__e
wangan10311223w_angan
wanglers123310033w_anglers
wangun1037103w_angun
wanly115118023w_an_ly
warble113516603w_arble
warsle93112923w_arsle
warstle10328013warstle
wattle94314213w_attle
whale115517433wha__le
whang124813383whang__
whanged15447613whanged
whangees15275063whangees
whangs13439723whang_s
whinge134311543whing_e
wiggle113713013w_iggle
windle104617953w_indle
winglet113115983w_inglet
winkle133812833w_inkle
wintle94014603w_intle
wirable121610963wira_ble
wrangling1456223wrangling
wrasse9398773wra_sse
wrassled12325383wrassled
wrassles11376713wrassles
wrastled12346433wrastled
wrastles11328933wrastles
wrestle10298843wrestle
wriggled14284663wriggled
wriggler13295263wriggler
wriggles13286263wriggles
wriggly15324893wriggly
wring95920713wring__
wringed123710193wringed
wringer113612453wringer
wrings104012973wring_s
wrinkled16275353wrinkled
wrinkles15296693wrinkles
wrinkly17295753wrinkly
wrong94712323wrong__
wronged12397673wronged
wronger11288823wronger
wrongs10338933wrong_s
wrung9549803wrung__

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.1401276364.3
2DLD Change Limit1340272637.14318763.4
3Display Results2632630.0902922.2
 (SQL Overall)1786912637.37324235.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.