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

215 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
spurtles103778(None) 
spurtle937451spurtle_
hurtles103913752_hurtles
purfles122511852_purfles
purples112712832_purples
scuttles1056502scuttles
shuttles1136552shuttles
sparkles143210492sparkles
spittles1038332spittles
sporules1037702sporules
spurges104111652spur_ges
spurries102311322spurries
spurted103111972spurt_ed
spurter94013002spurt_er
spurters103311702spurters
spurts84814972spurt__s
startles82111962startles
turtles72914342_turtles
apostles1037753apostles
burbles114916803_burbles
burgles105615963_burgles
bustles93816323_bustles
butles84423913_bu_tles
chortles133611323chortles
curdles103814573_curdles
cuttles93613923_cuttles
dartles84014133_dartles
empurples1542013empurples
epistles1047783epistles
gruntles9287233gruntles
gurgles94312873_gurgles
guttles83011933_guttles
hurdles113613373_hurdles
hurtle93512943_hurtle_
hurtled11339593_hurtled
hurtless11307783_hurtless
hustles103414173_hustles
justles143311433_justles
kirtles11309663_kirtles
myrtles1235733_myrtles
parles86334413_par_les
paroles95025893_paroles
parties93230873_parties
partlet92720363_partlet
partlets102811523_partlets
pestles93217693_pestles
pettles93916483_pettles
pintles94118733_pintles
portless10310643_portless
pottles93816983_pottles
proles84627203_p_roles
puddles113613823_puddles
pules74538813_pu__les
pungles104013713_pungles
punties94520783_punties
purees84721683_pur_ees
purfle112511183_purfle_
purfled13248733_purfled
purfler12248733_purfler
purflers13216973_purflers
purges94421763_pur_ges
purines94420773_purines
purities10316283_purities
purled94520753_pur_led
purls74723353_pur_l_s
purple102712683_purple_
purpled12299783_purpled
purpler11289273_purpler
purplest12249133_purplest
purses84826373_pur_ses
pursues94111373_pursues
purtier93214093_purtier
purtiest102414113_purtiest
pustules1038443_pustules
puttees93612913_puttees
putties94420023_putties
putzes174212523_pu_tzes
puzzles17318973_puzzles
rustles73416413_rustles
safroles1136933safroles
saurels749303saurel_s
sauries72821623saur_ies
sautes63924913sau_t_es
scruples1237433scruples
scuffles16287863scuffles
scumbles1447023scumbles
scurries102911483scurries
scurvies13248123scurvies
scutes85219193scu_t_es
scuttle936463scuttle_
scuttled1134533scuttled
settles73916003s_ettles
shirtless12266413shirtless
shorties11414583shorties
shuffles17297783shuffles
shutes93518223shu_t_es
shuttle1046103shuttle_
shuttled1234673shuttled
shuttler1164903shuttler
shuttlers1254123shuttlers
skirtless13254423skirtless
skittles1245763skittles
slurries82710413slurries
smarties10312873smarties
smuggles12225443smuggles
snuffles14318413snuffles
snuggles10306143snuggles
sorties74126403s_orties
souffles14298123souffles
sources9312173sour_ces
spackles16319953spackles
spaetzles2042153spaetzles
spales84728103sp__ales
spangles1138893spangles
sparables13167173sparables
spares84834553spar__es
sparges104016343spar_ges
sparkle133710213sparkle_
sparkled15317733sparkled
sparkler14317983sparkler
sparklers15315643sparklers
sparklet143110593sparklet
sparklets15275843sparklets
spates85028173sp_at_es
spathes125116533sp_athes
spatzles1935303spatzles
speckles16268133speckles
spectres12268683spectres
speltzes1944003speltzes
spherules1443823spherules
spicules12219803spicules
spiles84227913sp__iles
spindles112710353spindles
spinules10249333spinules
spiracles1345663spiracles
spiraled1137733spiraled
spirals93212513spiral_s
spiremes12397623spiremes
spires84628113spir__es
spiritless1243743spiritless
spirted103913073spirt_ed
spirts85317133spirt__s
spirulas10207203spirulas
spites84127333sp_it_es
spittle937923spittle_
spitzes1849183sp_itzes
splurges1145163splur_ges
spores84726613spor__es
sported104015433sport_ed
sporter93616553sport_er
sporters103714063sporters
sportier102010053sportier
sportiest111711033sportiest
sports84619183sport__s
sporule937273sporule_
spotless1037043sp_otless
spoutless1134243spoutless
sprattles1174883sprattles
sprees85620643sp_r_ees
sprites94220333sp_rites
spritzes1946943spritzes
spruces113810503sp_ruces
sprues84515763sp_r_ues
spues75025383spu___es
spumes1021314883spu__mes
spumones1254953spumones
spunkies14227593spunkies
spurgalls1243093spurgalls
spurge93711323spur_ge_
spurious1036963spurious
spurned10339263spur_ned
spurner9269653spur_ner
spurners10288493spurners
spurns84811383spur__ns
spurred103610623spur_red
spurrer93710223spur_rer
spurrers10338463spurrers
spurrey12307813spur_rey
spurreys13364603spurreys
spurrier10297693spurrier
spurriers11245063spurriers
spurs74621523spur___s
spurt77227983spurt___
spurting113111633spurting
sputter94014053spu_tter
sputters104012873sputters
startle72511123startle_
startled9208563startled
startler8248793startler
startlers9236743startlers
stubbles1236843stubbles
stumbles1237493stumbles
sturdies92110273sturdies
sturts63915143sturt__s
subrules1039733subrules
subtle82113433s_ubtle_
subtler92910853s_ubtler
subtlest10511363s_ubtlest
suckles134516743s_uckles
suites63727403s_uit_es
supples11511283s_upples
supremes1238363supremes
sureties8316583s_ureties
surges73924593s_ur_ges
surplus936793s_urplus
surtaxes1536513s_urtaxes
surtitles945633s_urtitles
sutler63718393s_u_tler
sutlers73116973s_u_tlers
suttees74114063s_uttees
turtle63213573_turtle_
turtled8309683_turtled
turtler72610323_turtler
turtlers8258203_turtlers
whortles14306743whortles

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 Filter1786911461620.436409841.7
2DLD Change Limit1461622156.76621602.4
3Display Results2152150.0932311.8
 (SQL Overall)1786912157.29524495.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.