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

185 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
scurvier1325588(None) 
curvier123110661_curvier
scurfier13267051scurfier
scurvies13248121scurvies
curdier103312622_curdier
curlier93314182_curlier
currier93316702_currier
scarier94017872scar_ier
scarrier10298452scarrier
scummier1445082scummier
scurried11267052scurried
scurries102911482scurries
scurviest14266122scurviest
scurvily1643782scurvily
scuzzier1842712scuzzier
spurrier10297692spurrier
sturdier9216962sturdier
surfier102613542s_urfier
surlier72915442s_urlier
surviver1434682s_urviver
blurrier1035163blurrier
bouvier1277433bou_vier
burier84324653_bur_ier
burlier93514413_burlier
burrier93613553_burrier
carrier93619583_carrier
carver114420153_carv_er
clavier1239173_clavier
corkier133114303_corkier
cornier93017093_cornier
courier93617893cour_ier
courtier1059333courtier
crier74724463_c_r_ier
culver113010633_culv_er
cuppier1368323_cuppier
curber104517053_cur_ber
curdler103511563_curdler
curer75030753_cur__er
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
curve104920023_curv_e_
curved124815223_curv_ed
curves114619283_curv_es
curvet114720243_curv_et
curvey144111843_curv_ey
curviest13309673_curviest
curving133912103_curving
cushier123610833_cushier
furrier103513663_furrier
furzier19318103_furzier
hurrier103412943_hurrier
knurlier1242883knurlier
murkier133110273_murkier
nervier10298833_nervier
pursier94012753_pursier
purtier93214093_purtier
purview1534233_purview
sarkier113413313s_arkier
saucier9810283sau_cier
sauries72821623saur_ies
savvier1335483s_avvier
scabbier1435133scabbier
scalier94316913sc_alier
scantier10309983scantier
scarcer113911373scar_cer
scareder1135793scareder
scarer84524613scar__er
scarfer124511083scar_fer
scarifier1446653scarifier
scarper114814823scar_per
scarves124511623scarv_es
scattier10267583scattier
schizier2234063schizier
scorcher15196793scorcher
scorer84818263scor__er
scorifier1445413scorifier
scorner9259763scor_ner
scourer93910433scour__er
scourger1134723scour_ger
scraper114513423sc_raper
screwer124410073sc_rewer
screwier1346433screwier
scriber113910973sc_riber
scried95817303sc_r_ied
scries85226823sc_r_ies
scrive115414943sc_rive_
scrived134511113sc_rived
scrives124414273sc_rives
scrubber1434123scrubber
scrubbier1543333scrubbier
scruffier1743303scruffier
scuffer15328883scu_ffer
scuffler16286703scuffler
sculker13318323scu_lker
sculler99812153scu_ller
scummer13398753scu_mmer
scunner9358243scu_nner
scupper1367423scu_pper
scurfiest14236863scurfiest
scurril945113scurri_l
scurrile1055073scurrile
scurviness1543283scurviness
scurvy14386103scurv__y
scutcher15176963scutcher
scutter93512173scu_tter
securer958253secur__er
server94917713s_erv_er
servicer1335263s_ervicer
shelvier1464913shelvier
shirtier1137943shirtier
shriver134712193s_hriver
sirupier1034303sirupier
skunkier11174283skunkier
sludgier1034823sludgier
slummier1235473slummier
slurried9285943slurried
slurries82710413slurries
slushier1135983slushier
sluttier836453sluttier
smarmier1235033smarmier
smirkier1444433smirkier
smudgier1233753smudgier
smuttier1035213smuttier
snarkier12336513snarkier
snarlier8278183snarlier
snubbier1244993snubbier
snuffier14276943snuffier
sorrier72313733s_orrier
soupier93111753sou_pier
sourer63620213sour__er
sparkier14298033sparkier
sparrier10329143sparrier
spirier93214073spir_ier
splurgier1252343splurgier
sportier102010053sportier
sprier84119063s_pr_ier
sprucier1254793sprucier
spumier1137903spu_mier
spunkier14235823spunkier
spurner9269653spur_ner
spurrer93710223spur_rer
spurriers11245063spurriers
spurries102311323spurries
spurter94013003spur_ter
squirmier2042853squirmier
starrier8279463starrier
starver104611993starv_er
stormier1036103stormier
striver104315203s_triver
stubbier1235353stubbier
studier82510053stu_dier
studlier935473studlier
stuffier14336623stuffier
stuiver10447083stuiv_er
stumpier1255883stumpier
sturdied10215963sturdied
sturdies92110273sturdies
suaver93014233s_uav_er
suckier133613973s_uckier
sudsier868783s_udsier
sulkier113811963s_ulkier
sunnier73412153s_unnier
surer54833103s_ur__er
surfer93515883s_ur_fer
surger74320093s_ur_ger
surmiser1036763s_urmiser
surveil1045093s_urveil
survey124111673s_urv_ey
survive1335933s_urvive
survived1534073s_urvived
survivers1543883s_urvivers
survives1436333s_urvives
survivor1442403s_urvivor
swerver1365733swerv_er
swirlier1135213swirlier
syrupier1343053syrupier
turfier10249793_turfier

Search took 10 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.453394461.4
2DLD Change Limit1461621859.31315694.4
3Display Results1851850.0762434.2
 (SQL Overall)1786911859.84218156.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.