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

109 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
straggled1229685(None) 
straggle10359131straggle_
straggler11377291straggler
straggles11328501straggles
strangled11268981strangled
struggled12304301struggled
draggled1254672_draggled
scragged1335822scragg_ed
stagged104212082st_agg_ed
straddled12205022straddled
stragglers12305252stragglers
stragglier1243502stragglier
straggly13355562straggl_y
strangle98411502strangle_
strangler10369472strangler
strangles103011552strangles
struggle10345052struggle_
struggler11264552struggler
struggles11255282struggles
bedraggled1641653bedraggled
bragged12449843_bragg_ed
cragged12479883_cragg_ed
daggled11329463__daggled
dragged11379563_dragg_ed
draggle1056103_draggle_
draggles1145963_draggles
estranged11387663estrang_ed
fragged134010163_fragg_ed
gaggled11359913__gaggled
haggled13359283__haggled
ragged94620263__ragg_ed
raggle83712883__raggle_
raggles93813283__raggles
sagged94120013s__agg_ed
scrabbled16154973scrabbled
scraggier1344133scraggier
scragglier1442283scragglier
scraggly15294143scraggl_y
scraighed1643593scraighed
scrambled16164813scrambled
scrawled1445903scra_wled
shagged134210133s_hagg_ed
shrugged1433673shrugg_ed
slagged104312773s_lagg_ed
smuggled13254223s_muggled
snagged104010673s_nagg_ed
sniggled11275743s_niggled
snuggled11234953s_nuggled
spangled1236153s_pangled
spraddled14203463spraddled
sprattled1263313sprattled
sprawled1434523spra_wled
sprigged13316223sprigg_ed
squiggled2142453squiggled
stabled103514953st_a_bled
staged84521563st_a_g_ed
staggard1144513st_aggard
stagger94212393st_agg_er
staggered1244473st_aggered
staggie9138463st_aggie_
staggier10167513st_aggier
staggies101210323st_aggies
staled74728103st_a__led
stalled83515683st_a_lled
stanged94113843st_ang_ed
stapled103613703st_a_pled
stargazed2043073stargazed
startled9208563st_artled
straddle10186223straddle_
straddler11205113straddler
straddles11216403straddles
strafed114413333stra__fed
straggliest1343613straggliest
straggling1344303straggling
straighted1544863straighted
strained9412253stra_ined
straked125415343stra__ked
stranded102710813stra_nded
strange85416343strang_e_
strangely1345413strangely
stranger94715103strang_er
strangered1245413strangered
stranges94516763strang_es
stranglers11396823stranglers
strapped1357823stra_pped
stravaged1444193stravaged
strawed114813613stra__wed
strayed114513283stra__yed
streeled9267863str_eeled
strickled1665833strickled
stringed102911873string_ed
strolled937813str_olled
strugglers12273063strugglers
swagged13419153s_wagg_ed
tagged93418123_t_agg_ed
tangled94214633_t_angled
toggled10428653_t_oggled
trachled1438313_trachled
trailed83415673_tra_iled
trameled11309073_trameled
trampled13247903_trampled
traveled12349453_traveled
trawled113411523_tra_wled
triangled1143943_triangled
trigged10359853_trigg_ed
twangled1364173_twangled
waggled13389363__waggled
wrangled1335593_wrangled
wriggled14284663_wriggled

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.1561145455.1
2DLD Change Limit1486411096.81321817.3
3Display Results1091090.0303633.3
 (SQL Overall)1786911096.99925530.9
 
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.