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

225 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
spurrier1029769(None) 
sparrier10329141sparrier
spurrer93710221spurr_er
spurriers11245061spurriers
spurries102311321spurries
blurrier1035162blurrier
burrier93613552_burrier
currier93316702_currier
furrier103513662_furrier
hurrier103412942_hurrier
parrier93717652_parrier
pursier94012752_pursier
purtier93214092_purtier
scarrier10298452scarrier
scurfier13267052scurfier
scurried11267052scurried
scurries102911482scurries
scurvier13255882scurvier
slurried9285942slurried
slurries82710412slurries
sorrier72313732s_orrier
sparkier14298032sparkier
spherier1337782spherier
spirier93214072sp_irier
splurgier1252342splurgier
sportier102010052sportier
sprier84119062sp__rier
sprucier1254792sprucier
spumier1137902spu_mier
spunkier14235822spunkier
spurner9269652spu_rner
spurred103610622spurr_ed
spurrers10338462spurr_ers
spurrey12307812spurr_ey
spurring11339762spurring
spurter94013002spu_rter
starrier8279462starrier
sturdier9216962sturdier
surfier102613542s_urfier
surlier72915442s_urlier
barrier94017733_barrier
burier84324653_bu_rier
burlier93514413_burlier
burrer83718473_burr_er
carrier93619583_carrier
charrier1378683charrier
courier93617893cou_rier
courtier1059333courtier
curdier103312623_curdier
curlier93314183_curlier
currie84317263_currie_
curried103313653_curried
curriers103410753_curriers
curriery13326163_curriery
curries93723163_curries
curvier123110663_curvier
dhurrie1153953dhurrie_
dhurries1255583dhurries
durrie73713263_durrie_
durries83817353_durries
farrier103514893_farrier
firrier103410133_firrier
flurried12235283flurried
flurries11188913flurries
furriers11369493_furriers
furriery14395683_furriery
furriner11267303_furriner
furzier19318103_furzier
gurries83515953_gurries
harrier104417753_harrier
hurried113511043_hurried
hurriers11358893_hurriers
hurries103919653_hurries
knurlier1242883knurlier
marrier93817523_marrier
merrier92612303_merrier
murkier133110273_murkier
murries94118673_murries
parried103615723_parried
parriers103612903_parriers
parries93925843_parries
partier93520713_partier
perkier133813123_perkier
perries93226603_perries
porkier133712343_porkier
pornier93413133_pornier
prier75027763_p__rier
pudgier11377723_pudgier
puffier1547973_puffier
puggier11309383_puggier
pulpier1148623_pulpier
punier84519223_pu_nier
punkier133512793_punkier
punnier93511263_punnier
purer75127903_pu_r_er
purfler12248733_purfler
purger94717233_pu_rger
purifier1338573_purifier
purlieu938143_purlieu
purpler11289273_purpler
purred94218073_purr_ed
purring104515823_purring
purser85020473_pu_rser
pursuer9338893_pursuer
purview1534233_purview
pushier123611093_pushier
pussier93711993_pussier
puttier93314503_puttier
quarrier1736843quarrier
querier16310013_querier
sarkier113413313s_arkier
saucier9810283sau_cier
sauries72821623sau_ries
savorier1136643savorier
scarier94017873s_carier
scummier1445083scummier
scurril945113scurri_l
scurrile1055073scurrile
scurvies13248123scurvies
scuzzier1842713scuzzier
serried82513963s_erried
serries73925353s_erries
sherries111812893sherries
shirtier1137943shirtier
sirupier1034303sirupier
skerries12168673skerries
skunkier11174283skunkier
sludgier1034823sludgier
slummier1235473slummier
slurred8359193slurr_ed
slurring9288833slurring
slushier1135983slushier
sluttier836453sluttier
smarmier1235033smarmier
smearier1036953smearier
smirkier1444433smirkier
smudgier1233753smudgier
smuttier1035213smuttier
snarkier12336513snarkier
snarlier8278183snarlier
sneerier878103sneerier
snubbier1244993snubbier
snuffier14276943snuffier
soupier93111753sou_pier
sourer63620213sou_r_er
spacier114011633sp_acier
sparer84524963sp_ar_er
sparger103613083sp_arger
sparker133914363sp_arker
sparkler14317983sparkler
sparklier1554363sparklier
sparred104512863sparr_ed
sparriest11198793sparriest
sparring113112223sparring
sparser94311483sp_arser
spearer93913663spear_er
speedier1146623speedier
spendier1147143spendier
spicier115112463sp_icier
spiderier1244653spiderier
spier75728033sp___ier
spiffier16255883spiffier
spikier13369983sp_ikier
spinier93715163sp_inier
splurger1143813splurger
spongier1135743spongier
spookier14175493spookier
spoonier10167653spoonier
sporter93616553sp_orter
spottier10207313spottier
sprayer12369043sp_rayer
sprucer11317683sp_rucer
spryer11418533sp__ryer
spudder11256553spu_dder
spunkie13215303spunkie_
spunkies14227593spunkies
spurge93711323spu_rge_
spurges104111653spu_rges
spurned10339263spu_rned
spurners10288493spu_rners
spurning11258663spurning
spurreys13364603spurreys
spurry11429123spurr__y
spurted103111973spu_rted
spurters103311703spu_rters
spurting113111633spurting
spurtle937453spurtle_
spurtles1037783spurtles
sputter94014053spu_tter
squarer163410663squar_er
squirmer1934373squirmer
squirmier2042853squirmier
squirter1746523squirter
stirrer7338233stirr_er
stormier1036103stormier
stubbier1235353stubbier
studier82510053stu_dier
studlier935473studlier
stuffier14336623stuffier
stumpier1255883stumpier
sturdied10215963sturdied
sturdies92110273sturdies
suckier133613973s_uckier
sudsier868783s_udsier
sugarier937393sugarier
sulkier113811963s_ulkier
sultrier837773sultrier
sunnier73412153s_unnier
superber1239693superber
superior10310883superior
supplier1246603supplier
supremer1246483supremer
surer54833103s_u_r_er
surfer93515883s_u_rfer
surger74320093s_u_rger
surmiser1036763s_urmiser
surpriser1144613s_urpriser
surrey94414583s_urr_ey
surviver1434683s_urviver
swirlier1135213swirlier
syrupier1343053syrupier
tarrier74323173_tarrier
terrier73414963_terrier
turfier10249793_turfier
worrier102311683_worrier

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.533335255.2
2DLD Change Limit1461622256.35622995.9
3Display Results2252250.0962343.8
 (SQL Overall)1786912256.98525582.1
 
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.