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

222 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
spurtle93745(None) 
spurtles1037781spurtles
hurtle93512942_hurtle
purfle112511182_purfle
purple102712682_purple
scuttle936462scuttle
shuttle1046102shuttle
sparkle133710212sparkle
spittle937922spittle
sporule937272sporule
spurge93711322spur_ge
spurt77227982spurt__
spurted103111972spurted
spurter94013002spurter
spurts84814972spurt_s
startle72511122startle
subtle82113432s_ubtle
turtle63213572_turtle
apostle937853apostle
asparkle1443843asparkle
burble104617703_burble
burgle94815863_burgle
bustle84015483_bustle
butle75023103_bu_tle
chortle124210443chortle
courtly1256923courtly
curdle95514313_curdle
curtly1149283_curtly
curule83614123_curule
cuttle84113893_cuttle
dartle73714833_dartle
empurple1442183empurple
epistle957893epistle
gruntle8257053gruntle
gurgle83912473_gurgle
guttle74111973_guttle
hurdle103712793_hurdle
hurtled11339593_hurtled
hurtles103913753_hurtles
hustle93113993_hustle
justle133211583_justle
kirtle10309473_kirtle
myrtle1135733_myrtle
parle75836163_par_le
parole84425253_parole
partlet92720363_partlet
partly116315473_partly
pertly115312553_pertly
pestle83215843_pestle
pettle84116053_pettle
pintle83818263_pintle
portly114713403_portly
pottle84416103_pottle
prole74527793_p_role
puddle103914153_puddle
puerile9310093_puerile
pule65040953_pu__le
pungle94413573_pungle
pure65543333_pur__e
puree74632843_pur_ee
purely114013633_purely
purfled13248733_purfled
purfler12248733_purfler
purfles122511843_purfles
purge85324603_pur_ge
purine85321893_purine
purl65631423_pur_l_
purled94520753_pur_led
purls74723353_pur_ls
purpled12299783_purpled
purpler11289273_purpler
purples112712833_purples
purply13369053_purply
purse76028893_pur_se
pursue84512253_pursue
purtier93214093_purtier
purty105019403_purt_y
pustule937683_pustule
puttee85919723_puttee
puttie84116303_puttie
puzzle16318603_puzzle
rustle63615413_rustle
safrole1037253safrole
saurel6511993saurel_
saurels749303saurels
saute55028083sau_t_e
scruple1137193scruple
scuffle15266893scuffle
scumble1337013scumble
scurrile1055073scurrile
scute75520943scu_t_e
scuttled1134533scuttled
scuttles1056503scuttles
settle63915663s_ettle
shortie10411343shortie
shortly13387573shortly
shuffle16276923shuffle
shute84520353shu_t_e
shuttled1234673shuttled
shuttler1164903shuttler
shuttles1136553shuttles
skittle1135533skittle
smartie9310173smartie
smartly12497433smartly
smuggle11265013smuggle
snuffle13267833snuffle
snuggle9275713snuggle
sortie63621993s_ortie
souffle13306803souffle
source8410673sour_ce
sourly93612213sour_ly
spackle15369573spackle
spaetzle1942243spaetzle
spale74929213sp__ale
spangle1038403spangle
sparable121611983sparable
spare75135563spar__e
sparely123410673sparely
sparge94216053spar_ge
sparkled15317733sparkled
sparkler14317983sparkler
sparkles143210493sparkles
sparklet143110593sparklet
sparkly16348133sparkly
sparse84516343spar_se
spartan948333spartan
spate74731583sp_at_e
spathe115115693sp_athe
spatzle1834583spatzle
speckle15297553speckle
spectre11297773spectre
spherule1343843spherule
spicule11269933spicule
spile75230083sp__ile
spindle103210093spindle
spinule9299993spinule
spiracle1255803spiracle
spiral83715343spiral_
spiraled1137733spiraled
spirals93212513spirals
spire75828693spir__e
spireme11478363spireme
spirt75032953spirt__
spirted103913073spirted
spirts85317133spirt_s
spirula9257703spirula
spirulae10216573spirulae
spite75430663sp_it_e
spittles1038333spittles
splurge1044763splur_ge
sporal82915453sporal_
spore75428593spor__e
sport75935983sport__
sported104015433sported
sporter93616553sporter
sportier102010053sportier
sportif1238803sportif
sportily1337733sportily
sportive1348333sportive
sports84619183sport_s
sporty115112493sport_y
sporules1037703sporules
sprattle1054763sprattle
spree74830863sp_r_ee
sprite84421773sp_rite
spruce103910873sp_ruce
sprue74717633sp_r_ue
spryly1435513sp_ryly
spue66025523spu___e
spume95817313spu__me
spumone1154383spumone
spunkie13215303spunkie
spur65321193spur___
spurgall1143263spurgall
spurges104111653spurges
spurn74815453spur__n
spurned10339263spurned
spurner9269653spurner
spurns84811383spur_ns
spurred103610623spurred
spurrer93710223spurrer
spurrey12307813spurrey
spurrier10297693spurrier
spurries102311323spurries
spurry11429123spur_ry
spurs74621523spur__s
spurters103311703spurters
spurting113111633spurting
sputa74612963spu_t_a
sputter94014053sputter
sputum1035943spu_tum
squatly1946433squatly
startled9208563startled
startler8248793startler
startles82111963startles
sterile7316603sterile
stubble1136843stubble
stumble1147553stumble
sturt56028963sturt__
sturts63915143sturt_s
suable83920553s_uable
subrule939643subrule
subtile91912623s_ubtile
subtler92910843s_ubtler
subtly11249263s_ubtly
suckle124015963s_uckle
suite54829563s_uit_e
supple10410203s_upple
supreme1137893supreme
sural55931263s_ural_
sure45447413s_ur__e
surely93816463s_urely
surge65027693s_ur_ge
surly85124433s_ur_ly
surtax1337843s_urtax
surtitle845283s_urtitle
sutler63718393s_u_tler
suttee63721543s_uttee
turtled8309683_turtled
turtler72610323_turtler
turtles72914343_turtles
whortle13335943whortle

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272226.00022337.8
3Display Results2222220.0932387.1
 (SQL Overall)1786912226.48327563.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.