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 “straggler” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
straggler1137729(None) 
straggle10359131straggle_
straggled12296851straggled
stragglers12305251stragglers
straggles11328501straggles
stragglier1243501stragglier
strangler10369471strangler
struggler11264551struggler
scraggier1344132scraggier
scragglier1442282scragglier
stagger94212392st_agg_er
staggier10167512st_aggier
straddler11205112straddler
straggly13355562straggl_y
stranger94715102strang_er
strangle98411502strangle_
strangled11268982strangled
stranglers11396822stranglers
strangles103011552strangles
struggle10345052struggle_
struggled12304302struggled
strugglers12273062strugglers
struggles11255282struggles
bragger113810043_bragg_er
braggier12136453_braggier
craggier12116063_craggier
dragger10309173_dragg_er
draggier11135773_draggier
draggle1056103_draggle_
draggled1254673_draggled
draggles1145963_draggles
estranger10447843estrang_er
haggler12328933__haggler
raggle83712883__raggle_
raggles93813283__raggles
sagger84321073s__agg_er
saggier92912063s__aggier
scrabbler15195203scrabbler
scragged1335823scragg_ed
scraggly15294143scraggl_y
scrambler15165043scrambler
scrawler1345893scra_wler
scroggier1343133scroggier
shaggier13116053s_haggier
slaggier10126953s_laggier
smuggler12244523s_muggler
snaggier10136303s_naggier
sniggler10396113s_niggler
sprawler1334653spra_wler
sprigger12366503sprigg_er
spriggier1343843spriggier
stabler94014933st_a_bler
stager74821343st_a_g_er
stagged104212083st_agg_ed
staggerer1143923st_aggerer
staggers10379843st_agg_ers
staggery13346243st_agg_ery
staggie9138463st_aggie_
staggies101210323st_aggies
stagier83513443st_a_gier
staler64025823st_a__ler
stapler93913633st_a_pler
stargazer1942593stargazer
startler8248793st_artler
stealer72913973stea__ler
straddle10186223straddle_
straddled12205023straddled
straddlers12203823straddlers
straddles11216403straddles
strafer103912463stra__fer
straggliest1343613straggliest
straggling1344303straggling
straighter1444493straighter
strainer8512223stra_iner
straiter8311783stra_iter
strander97112063stra_nder
strange85416343strang_e_
strangely1345413strangely
strangers104112163strang_ers
stranges94516763strang_es
strapper1258093stra_pper
strappier1345133strappier
strawier1137493stra_wier
strayer104312503stra__yer
stringer93812943string_er
stringier1036713stringier
stroller848173str_oller
stronger9349693strong_er
swagger12389333s_wagg_er
tagger84017703_t_agg_er
tangler83515073_t_angler
toggler9399193_t_oggler
trailer73015393_tra_iler
trampler12278013_trampler
traveler11328433_traveler
trawler104011903_tra_wler
trigger9329163_trigg_er
twangler1244113_twangler
wrangler1245473_wrangler
wriggler13295263_wriggler

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411006.39023261.5
3Display Results1001000.0462173.9
 (SQL Overall)1786911006.85926052.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.