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

202 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
scurfier1326705(None) 
scurvier13255881scurvier
surfier102613541s_urfier
curdier103312622_curdier
curlier93314182_curlier
currier93316702_currier
curvier123110662_curvier
scarfer124511082scarf_er
scarier94017872scar_ier
scarifier1446652scarifier
scarrier10298452scarrier
scorifier1445412scorifier
scruffier1743302scruffier
scuffer15328882scu_ffer
scuffler16286702scuffler
scummier1445082scummier
scurfiest14236862scurfiest
scurried11267052scurried
scurries102911482scurries
scurvies13248122scurvies
scuzzier1842712scuzzier
snuffier14276942snuffier
spurrier10297692spurrier
stuffier14336622stuffier
sturdier9216962sturdier
surfer93515882s_urf_er
surlier72915442s_urlier
turfier10249792_turfier
blurrier1035163blurrier
buffier1568403_buffier
burier84324653_bur_ier
burlier93514413_burlier
burrier93613553_burrier
carrier93619583_carrier
chuffier1934543chuffier
comfier1439163_comfier
corkier133114303_corkier
cornier93017093_cornier
courier93617893cour_ier
courtier1059333courtier
crier74724463_c_r_ier
cuppier1368323_cuppier
curber104517053_cur_ber
curdler103511563_curdler
curer75030753_cur__er
curfew14426743_curf_ew
curie74533043_cur_ie_
curies84934023_cur_ies
curler85221323_cur_ler
currie84317263_currie_
curried103313653_curried
curriers103410753_curriers
curriery13326163_curriery
curries93723163_curries
curser84721473_cur_ser
curter85320083_cur_ter
cushier123610833_cushier
fluffier13264333fluffier
furrier103513663_furrier
furzier19318103_furzier
gruffier1544703gruffier
gulfier1137793_gulfier
huffier1637493_huffier
hurrier103412943_hurrier
knurlier1242883knurlier
murkier133110273_murkier
puffier1547973_puffier
purfler12248733_purfler
purifier1338573_purifier
pursier94012753_pursier
purtier93214093_purtier
sarkier113413313s_arkier
saucier9810283sau_cier
sauries72821623saur_ies
scabbier1435133scabbier
scalier94316913sc_alier
scantier10309983scantier
scarcer113911373scar_cer
scareder1135793scareder
scarer84524613scar__er
scarfed134711183scarf_ed
scarfers13408463scarf_ers
scarfing14309713scarfing
scarified1547293scarified
scarifiers1544103scarifiers
scarifies1439603scarifies
scarper114814823scar_per
scattier10267583scattier
schizier2234063schizier
sclaffer16112653sclaffer
scoffer15317023sc_offer
scorcher15196783scorcher
scorer84818263scor__er
scorified1546193scorified
scorifiers1543603scorifiers
scorifies1448023scorifies
scorner9259763scor_ner
scourer93910433scour__er
scourger1134723scour_ger
scraper114513423sc_raper
screwer124410073sc_rewer
screwier1346433screwier
scriber113910973sc_riber
scried95817303sc_r_ied
scries85226823sc_r_ies
scrubber1434123scrubber
scrubbier1543333scrubbier
scuffed16298243scu_ffed
scuffers16307493scu_ffers
scuffing17287113scuffing
scuffle15266893scuffle_
scuffled17256203scuffled
scufflers17285033scufflers
scuffles16287863scuffles
sculker13318323scu_lker
sculler99812153scu_ller
scummer13398753scu_mmer
scunner9358243scu_nner
scupper1367423scu_pper
scurf104719323scurf___
scurfs113210813scurf__s
scurfy14338763scurf__y
scurril945113scurri_l
scurrile1055073scurrile
scurviest14266123scurviest
scurvily1643783scurvily
scutcher15176963scutcher
scutter93512173scu_tter
securer958253secur__er
shirtier1137943shirtier
shuffler17306803shuffler
sirupier1034303sirupier
skunkier11174283skunkier
sludgier1034823sludgier
slummier1235473slummier
slurried9285943slurried
slurries82710413slurries
slushier1135983slushier
sluttier836453sluttier
smarmier1235033smarmier
smirkier1444433smirkier
smudgier1233753smudgier
smuttier1035213smuttier
snarkier12336513snarkier
snarlier8278183snarlier
sniffier14356643sniffier
snubbier1244993snubbier
snuffer13318853snu_ffer
snuffler14317413snuffler
snufflier1543303snufflier
sorrier72313733s_orrier
soupier93111753sou_pier
sourer63620213sour__er
sparkier14298033sparkier
sparrier10329143sparrier
spiffier16255883spiffier
spirier93214073spir_ier
splurgier1252343splurgier
sportier102010053sportier
sprier84119063s_pr_ier
sprucier1254793sprucier
spumier1137903spu_mier
spunkier14235823spunkier
spurner9269653spur_ner
spurrer93710223spur_rer
spurriers11245063spurriers
spurries102311323spurries
spurter94013003spur_ter
squiffier2442843squiffier
squirmier2042853squirmier
starrier8279463starrier
stormier1036103stormier
stubbier1235353stubbier
studier82510053stu_dier
studlier935473studlier
stuffer13349793stu_ffer
stumpier1255883stumpier
stupefier1442653stupefier
sturdied10215963sturdied
sturdies92110273sturdies
suckier133613973s_uckier
sudsier868783s_udsier
suffer124314513s_u_ffer
sufficer16225823s_ufficer
sulkier113811963s_ulkier
sunnier73412153s_unnier
surefire1145213s_urefire
surer54833103s_ur__er
surfacer1345663s_urfacer
surfed103814463s_urf_ed
surfeit10310343s_urfeit
surfeiter1244713s_urfeiter
surfers103614133s_urf_ers
surfiest112414433s_urfiest
surfing112914483s_urfing
surfmen1235993s_urfmen
surger74320093s_ur_ger
surmiser1036763s_urmiser
surviver1434683s_urviver
swirlier1135213swirlier
syrupier1343053syrupier
thurifer1443273thurifer

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622026.45322650.2
3Display Results2022020.0932172.0
 (SQL Overall)1786912026.95225703.5
 
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.