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

137 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
strangled1126898(None) 
straggled12296851straggled
strangle98411501strangle_
strangler10369471strangler
strangles103011551strangles
estranged11387662estrang_ed
spangled1236152s_pangled
stanged94113842st_ang_ed
straddled12205022straddled
straggle10359132straggle_
straggler11377292straggler
straggles11328502straggles
stranded102710812stran_ded
strange85416342strang_e_
strangely1345412strangely
stranger94715102strang_er
strangered1245412strangered
stranges94516762strang_es
stranglers11396822stranglers
stringed102911872string_ed
struggled12304302struggled
tangled94214632_t_angled
triangled1143942_triangled
twangled1364172_twangled
wrangled1335592_wrangled
angled84219093___angled
arranged1036933arrang_ed
astringed1145693astring_ed
crankled15408153_crankled
dangled104013153__dangled
deranged1137693derang_ed
draggled1254673_draggled
embrangled1652463embrangled
entangled1184513entangled
estrange9488893estrang_e_
estranger10447843estrang_er
estranges10359983estrang_es
harangued1442773harangued
jangled164111563__jangled
mangled113615263__mangled
outranged11239043outrang_ed
pranged114512553_prang_ed
ranged84824313__rang_ed
rankled123910653__rankled
scrabbled16154973scrabbled
scragged1335823scra_gged
scraighed1643593scraighed
scrambled16164813scrambled
scrawled1445923scra_wled
shingled13358323s_hingled
singled93914683s__ingled
slanged94112853s_lang_ed
spangle1038403s_pangle_
spangles1138893s_pangles
spraddled14203463spraddled
sprattled1263313sprattled
sprawled1434523spra_wled
springed123911323spring_ed
springlet1257523springlet
sprinkled1633713sprinkled
stabled103514953st_a_bled
staged84521563st_a_g_ed
stagged104212083st_a_gged
staled74728103st_a__led
stalled83515693st_a_lled
stanched14208903st_anched
staned74824643st_an__ed
stanzaed1843873st_anzaed
stapled103613703st_a_pled
startled9208563st_artled
straddle10186223straddle_
straddler11205113straddler
straddles11216403straddles
strafed114413333stra__fed
stragglers12305253stragglers
stragglier1243503stragglier
straggly13355563straggl_y
straighted1544863straighted
strained9412253stra_ined
straked125415343stra__ked
strand74514823stran___d
strander97112063stran_der
strang75718313strang___
strangers104112163strangers
strangest103210843strangest
stranglehold176963stranglehold
strangling1256403strangling
strangulated1474033strangulated
strangury1343203strangury
strapped1357823stra_pped
stravaged1444193stravaged
strawed114813613stra__wed
strayed114513283stra__yed
streeled9267873str_eeled
strickled1665833strickled
stringer93812943string_er
stringier1036713stringier
stringless1145353stringless
strolled937823str_olled
stronger9349693strong_er
strongly1245953strongl_y
strongmen1244323strongmen
strongyle1343113strongyle_
strongyles1443233strongyles
struggle10345053struggle_
struggler11264553struggler
struggles11255283struggles
strunted957243strun_ted
surcingled1441883surcingled
swingled13337433s_wingled
syringed13377583syring_ed
tanged84622493_t_ang_ed
tangle74019953_t_angle_
tangler83515073_t_angler
tangles83920043_t_angles
tangoed9318833_t_angoed
tingled93712803_t_ingled
trachled1438313_trachled
trailed83415673_tra_iled
trameled11309073_trameled
trampled13247903_trampled
tranced104414173_tran_ced
traveled12349453_traveled
trawled113411523_tra_wled
triangle935533_triangle_
triangles1035743_triangles
trindled10388693_trindled
trundled10306393_trundled
twanged12387273_twang_ed
twangle1145803_twangle_
twangler1244113_twangler
twangles1245743_twangles
untangled1165123untangled
wangled123312413__wangled
wrangle1137383_wrangle_
wrangler1245473_wrangler
wrangles1237463_wrangles

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.436409841.7
2DLD Change Limit1486411377.11020905.9
3Display Results1371370.0632174.6
 (SQL Overall)1786911377.60923484.2
 
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.