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

460 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
spurner926965(None) 
spurned10339261spurned
spurners10288491spurners
spurrer93710211spurrer
spurter94013001spurter
burner83819202_burner
churner12298342churner
mourner938082mourner
pruner83413452_pruner
punner84918152_punner
purer75127902_pur_er
purger94717232_purger
purser85020472_purser
scorner9259762scorner
scunner9358242scunner
shunner10358642shunner
sorner64720382s_orner
sourer63620212sour_er
spanner94312562spanner
sparer84524962spar_er
sparger103613072sparger
sparker133914352sparker
sparser94311482sparser
spawner12347362spawner
spinner93912262spinner
spirier93214072spirier
splurger1143802splurger
sporter93616552sporter
sprier84119062sp_rier
sprucer11317682sprucer
spryer11418532sp_ryer
spudder11256552spudder
spumier1137902spumier
spurge93711322spurge_
spurges104111652spurges
spurn74815452spurn__
spurns84811382spurn_s
spurred103610612spurred
spurrers10338452spurrers
spurrey12307802spurrey
spurrier10297682spurrier
spurted103111972spurted
spurters103311692spurters
sputter94014052sputter
sterner7411912sterner
stunner7349192stunner
surer54833092s_ur_er
surfer93515882s_urfer
surger74320092s_urger
turner63914612_turner
adorner8246973adorner
asperser10408303asperser
aspirer967903aspir_er
assurer767783assur_er
blurter9419833blurter
bourne83714093bourne_
bournes93615023bournes
burger94020793_burger
burier84324653_burier
burker125221173_burker
burler84723833_burler
burned95818963_burned
burners94115673_burners
burnet84326173_burnet
burrer83718473_burrer
churned13358373churned
churners13316883churners
corner84625623_corner
courier93617873courier
courser94114803courser
courter94516463courter
cunner83915003_cunner
curber104517053_curber
curer75030753_cur_er
curler85221323_curler
curser84721473_curser
curter85320073_curter
darner74017303_darner
dourer74215273dour_er
dunner73913823_dunner
durned84113173_durned
earner63617223_earner
funner93414103_funner
furler93616403_furler
garner73917003_garner
gunner73813983_gunner
gurnet74920873_gurnet
gurney10429413_gurney
hurler94717223_hurler
hurter93915853_hurter
impugner13444233impugner
impurer1136483impur_er
inurned8328053inurned
journey1734873journey
learner7319383learner
lurer54625313_lur_er
lurker103613293_lurker
mourned1037763mourned
mourners1036913mourners
murder93613783_murder
murker123715243_murker
nurser64314503_nurser
opener83910993op_ener
oppugner1341633oppugner
panner84224763_panner
pardner10239473_pardner
parer75839903_par_er
parker124121373_parker
parser84822373_parser
partner92811393_partner
pawner114212923_pawner
penner84616663_penner
perter84422283_perter
pinner84521503_pinner
planer84122653_planer
porker124917543_porker
pornier93413123_pornier
porter84224413_porter
pourer84516043pour_er
prier75027763_p_rier
prune75119633_prune_
pruned93413113_pruned
pruners93710723_pruners
prunes83419063_prunes
pryer104415313_p_ryer
pucker143817633_pucker
puffer144610733_puffer
puler74826623_pu_ler
puller83820813_puller
pulper103513273_pulper
pulser84215193_pulser
pumper124415553_pumper
punier84519223_punier
punker123718823_punker
punned93416193_punned
punners94114233_punners
punnet83518843_punnet
punnier93511263_punnier
punter84320023_punter
pure65543333_pur_e_
puree74632843_pur_ee
pureed95017803_pureed
purees84721683_purees
purfler12248733_purfler
purge85324603_purge_
purged104918263_purged
purgers104714003_purgers
purges94421763_purges
purine85321893_purine_
purines94420763_purines
purled94520743_purled
purpler11289263_purpler
purr64925813_pur__r
purred94218073_purred
purse76028893_purse_
pursed95220883_pursed
pursers93916093_pursers
purses84826373_purses
pursier94012753_pursier
pursuer9338893_pursuer
purtier93214093_purtier
purvey14559573_purvey
pusher114318283_pusher
putter83921443_putter
returner8397983returner
ruiner64013643_ruiner
runner63814463_runner
saner54334323s__aner
saucer84314103sau_cer
saucier9810283saucier
sauger74316253sau_ger
saunter72913453saunter
saurel6511983saur_el
sauries72821623sauries
scanner94411813scanner
scarcer113911373scarcer
scarer84524603scar_er
scarfer124511083scarfer
scarier94017873scarier
scarper114814823scarper
scorer84818253scor_er
scorned10229953scorned
scorners10228493scorners
scourer93910433scour_er
scourger1134723scourger
scuffer15328883scuffer
sculker13318323sculker
sculler99812153sculler
scummer13398753scummer
scunners10357303scunners
scupper1367423scupper
scurfier13267053scurfier
scurvier13255883scurvier
scutter93512173scutter
searer65432023sear_er
securer958253secur_er
seiner64622483s_einer
serener73415753serener
serer55935503s_er_er
serger73819733s_erger
server94917713s_erver
sharer95025483shar_er
sharker144313813sharker
sharper124312703sharper
shiner93820873s_hiner
shirker143711343shirker
shorter103515493shorter
shucker163710103shucker
shudder12297323shudder
shunned11417843shunned
shunners11317743shunners
shunter103611723shunter
shusher13288113shusher
shutter103712133shutter
signer74015633s_igner
sinner64320603s_inner
skinner11348093skinner
skirter11338483skirter
skulker10325683skulker
slubber113010763slubber
slugger93610673slugger
slumber113811003slumber
slummer113711203slummer
slurped10368753slurped
slurred8359183slurred
smarter94113133smarter
smirker13327423smirker
smugger11327053smugger
snarer64620843snar_er
snarler73610633snarler
snorer64316763snor_er
snorter74412653snorter
snubber11277733snubber
snuffer13318843snuffer
snugger9318313snugger
soarer64522243soar_er
sojourner1661713sojourner
sooner64220463s_ooner
sorer56236573s_or_er
sorned74820043s_orned
sorners73416863s_orners
sorrier72313723sorrier
sorter64425083s_orter
sounder83315383sounder
soupier93111753soupier
source8410673source_
sourced1038453sourced
sources9312173sources
soured74921863sour_ed
sourness839543sourness
souter64225923sou_ter
souther104116303souther
spacer104917793sp_acer
spacier114011633spacier
spader94317133sp_ader
spaller92713473spaller
spammer133410433spammer
spanker133612353spanker
spanned104111223spanned
spanners103710773spanners
spare75135563spar_e_
spared95427483spar_ed
sparers94519613spar_ers
spares84834553spar_es
sparge94216043sparge_
sparged113512753sparged
spargers11389733spargers
sparges104016333sparges
sparked143513133sparked
sparkers144111313sparkers
sparkier14298023sparkier
sparkler14317973sparkler
sparred104512853sparred
sparrier10329143sparrier
sparse84516343sparse_
spatter94016523spatter
spawned13316803spawned
spawners13396493spawners
speaker133311213speaker
speaned103411523speaned
spearer93913663spearer
specter113111733specter
speeder103811073speeder
speer74623903sp__eer
speller95415143speller
spelter94113703spelter
spencer113610973spencer
spender103713693spender
spewer115112143sp_ewer
sphene113412403sphene_
sphenes123013163sphenes
spherier1337783spherier
spicer104719313sp_icer
spicier115112463spicier
spider94516803sp_ider
spieler93111233spieler
spier75728033sp__ier
spiker124315663sp_iker
spikier13369983spikier
spiller92914323spiller
spine76534423sp_ine_
spined95423943sp_ined
spinel85317333sp_inel
spines85132033sp_ines
spinet85629753sp_inet
spinier93715163spinier
spinners103810863spinners
spinnery13416593spinnery
spinney12438923spinney
spinor839943sp_inor
spiraea9407983spiraea
spire75828693spir_e_
spirea84015633spir_ea
spired94921863spir_ed
spirem104214163spir_em
spires84628113spir_es
spirted103913073spirted
spitter94015183spitter
splicer114710523splicer
spline86020533spline_
splined105013113splined
splines94718893splines
splinter10329703splinter
splurge1044753splurge_
splurged1243913splurged
splurgers1253073splurgers
splurges1145153splurges
splurgier1252343splurgier
splutter10357443splutter
spoiler93310683spoiler
sponger1038523sponger
spoofer12368723spoofer
spooler93711383spooler
spooned103412443spooned
spooney12418243spooney
spoonier10167653spoonier
spore75428593spor_e_
spored94821793spor_ed
spores84726613spor_es
sported104015433sported
sporters103714053sporters
sportier102010053sportier
spotter94514873spotter
spouter94213223spouter
sprayer12369043sprayer
spree74830863sp_r_ee
sprees85620643sp_rees
sprent84522383sp_rent
springer113311753springer
sprinter103810813sprinter
spruce103910873spruce_
spruced12307523spruced
spruces113810503spruces
sprucier1254793sprucier
sprue74717633sp_rue_
sprues84515763sp_rues
sprung94610033sprun_g
spudded12235903spudded
spudders12255633spudders
spue66025523spu__e_
spued84918473spu__ed
spues75025383spu__es
spuing94313363spuin_g
spume95817313spu_me_
spumed114711543spu_med
spumes1021314883spu_mes
spumone1154383spumone_
spumones1254953spumones
spun66221463spu_n__
spunk114513403spu_n_k
spunked14307783spunked
spunkier14235813spunkier
spunks12349333spu_nks
spunky15427163spu_nky
spur65321193spu___r
spurning11258663spurning
spurreys13364593spurreys
spurriers11245063spurriers
spurries102311323spurries
spurry11429113spur_ry
spurs74621523spur__s
spurt77227983spur__t
spurtle937453spurtle
spurtles1037783spurtles
spurts84814973spur_ts
sputnik1372263sputnik
sputters104012863sputters
sputtery13366473sputtery
squander1835533squander
squarer163410653squarer
squinter1747353squinter
squirmer1934363squirmer
squirter1746513squirter
stainer73614923stainer
starer64027363star_er
starker114114693starker
starter73817873starter
starver104611993starver
stirrer7338223stirrer
stoner65823203s_toner
storer64721673stor_er
studier82510053studier
stuffer13349793stuffer
stuiver10447083stuiver
stumper113610093stumper
stunned8358893stunned
stunners8277923stunners
sturdier9216953sturdier
stutter72911463stutter
suaver93014233s_uaver
suber74924503s_u_ber
subnet82520933s_ubnet
suborner1047383suborner
sucker124120663s_ucker
sudser73511283s_udser
suer45334033s_u__er
suffer124314513s_uffer
suiter64121813s_uiter
sulker104015923s_ulker
summer104017713s_ummer
sunder74019823s_under
sunned74216323s_unned
sunnier73412153s_unnier
super74924483s_u_per
superber1239693superber
supine84216693supine_
supines94216383supines
supper104115433s_upper
suppler1148433suppler
supremer1246483supremer
sure45447413s_ur_e_
surfed103814463s_urfed
surfers103614133s_urfers
surfier102613543s_urfier
surge65027693s_urge_
surged84118883s_urged
surgers83517483s_urgers
surgery11319203s_urgery
surges73924593s_urges
surlier72915443s_urlier
surnamer1044883s_urnamer
surrey94414573s_urrey
survey124111663s_urvey
sutler63718393s_utler
swarmer1247803swarmer
swerver1365733swerver
swooner10358673swooner
tourer64115073tour_er
tourney1036273tourney
tuner56022683_tu_ner
turned73914473_turned
turners73912893_turners
turnery10357423_turnery
upturned11214013upturned
urger64116473__urger
usurer638103usur_er
usurper934353usurper
warner93717223_warner
yarner93313063_yarner
yearner10336873yearner

Search took 9 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.1731032896.0
2DLD Change Limit1340274608.54615683.0
3Display Results4604600.1533006.5
 (SQL Overall)1786914608.87220141.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.