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 “scries” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

135 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
scries8522682(None) 
cries75438401_cries
screes85023971screes
scribes113713201scribes
scried95817311scried
scrims104615931scrims
scrips105316031scrips
scrives124414271scrives
series64540971series
acres76327762acr_es
aeries64737782aeries
ascribes1246192ascribes
bries74942152_bries
buries84633272buries
caries85147622caries
cires74932912_cires
cribs94516752_cribs
cried84624292_cried
crier74724462_crier
criers83918582_criers
crimes105521582_crimes
cripes105120872_cripes
cris66233432_cri_s
crises84529432_crises
crits75527572_crits
curies84934022curies
decries103319812decries
descries11311922descries
dories75232362dories
dries64733672_dries
eyries93816812eyries
fries85535602_fries
furies95126372furies
juries134120632juries
kyries133411372kyries
lories64933042lories
paries84742522paries
pries74339532_pries
sanies63031952sanies
sarees65329942sarees
sarges75128592sarges
sarins63932622sarins
saris54544952sari_s
sauries72821622sauries
scabies11613332scabies
scales84529312scales
scapes105122262scapes
scares85033002scares
scarier94017872scarier
scariest101615952scariest
scarves124511622scarves
scenes84520352scenes
schriks16185742schriks
scones84521302scones
scopes104719592scopes
scores84725922scores
scrags95713802scrags
scrams105216622scrams
scrapes116217662scrapes
scrapies124612492scrapies
scraps106017242scraps
scree720031712scr_ee
screed95718932screed
screeds106210292screeds
screen85216022screen
screens95212182screens
screw109318542scr_ew
screws115513892screws
scribe104613532scribe
scribed124510642scribed
scriber113910972scriber
scribers12307962scribers
scrieve12448332scrieve
scrieves13387612scrieves
scrim95419742scri_m
scrimp125110582scrimp
scrimps13517902scrimps
scrip96619192scri_p
script105717902script
scripts11509372scripts
scrive115414942scrive
scrived134511112scrived
scrods94111612scrods
scrubs104210312scrubs
scrums104614252scrums
scurries102911482scurries
scurvies13248122scurvies
scutes85219192scutes
seres55448892ser_es
serges74225972serges
serifs94017052serifs
serines74229542serines
serins64029672serins
serries73925352serries
serves94423652serves
shies86136552s_hies
shires95225572shires
shriek134211102shriek
shrieks14377672shrieks
shrikes144412392shrikes
shrines104618692shrines
shris84221452shri_s
shrives134416172shrives
sickies133717502sickies
sirees64624582sirees
sires55945372sir_es
skies95026842s_kies
sores55454282sor_es
sorites73825242sorites
sorties74126402sorties
spies76037622s_pies
spires84628112spires
sprees85620642sprees
sprier84119062sprier
spriest92718652spriest
sprigs94814772sprigs
sprites94220332sprites
sprits85122532sprits
sprues84515762sprues
sris45434152s_ri_s
sties55132982s_ties
stories7324272stories
strides84520392strides
strifes104716582strifes
strikes114719092strikes
stripes95320572stripes
strips85719652strips
strives104119372strives
sucres84218892sucr_es
surges73924592surges
tories65435882tories
tries55742812_tries
usuries7510632usuries
varies94330872varies
wries85827742_wries

Search took 4 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 Filter178691825510.450397091.1
2DLD Change Limit825511352.86028864.0
3Display Results1351350.0462934.8
 (SQL Overall)1786911353.35653245.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.