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

197 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
spraining124815(None) 
straining10410561straining
braining113414682_braining
draining103312672_draining
graining102813182_graining
paining103920242_p_aining
plaining113911552_plaining
praising113214562_praising
prawning1446962_prawning
raining83922692__raining
saining83621392s__aining
sardining1137572sardining
shrining122610852shr_ining
spanning113311082sp_anning
spawning14296912sp_awning
speaning113512242spea_ning
splining11310772sp_lining
sprawling15175122sprawling
spraying14299882spra_ying
springing1338742spr_inging
sprinting12310032spr_inting
staining9413372s_taining
training93015862_training
upraising1237262upraising
appraising1545763appraising
aproning11311793apr_oning
arraigning1242783arraigning
attaining1047223attaining
bargaining1445213bargaining
braiding123112703_braiding
brailing113514793_brailing
braising113014563_braising
branning112911093_branning
brining103216473_br_ining
captaining1546073captaining
chaining142810783_chaining
craning103620303_cra_ning
curtaining1345533curtaining
deraigning1344103deraigning
derailing112011313derailing
detaining112510473detaining
detraining1267673detraining
dispraising1546043dispraising
distraining1346983distraining
engraining1245223engraining
entraining1147643entraining
explaining2044303explaining
gaining94015663__gaining
groining102310633_groining
ingraining1245623ingraining
margining1337603margining
mistraining1446503mistraining
obtaining1236773obtaining
opining10311743op__ining
ordaining1145753ordaining
paiking143814813_p_aiking
painting113614423_p_ainting
pairing103716733_p_airing
panning104019393_p_anning
patining11312303_patining
pawning134711413_p_awning
peining104619153_p_eining
pertaining1347993pertaining
pining93726533_p__ining
plaiting113113513_plaiting
planing103418253_pla_ning
planning113610223_planning
prancing132612163_prancing
pranging123012723_pranging
pranking153813383_pranking
prating103424453_pra_ting
praying133717323_pra_ying
preening113115843_preening
pricing123417343_pr_icing
priding113317543_pr_iding
priming123417373_pr_iming
prinking153212453_pr_inking
printing113216083_pr_inting
prising103321453_pr_ising
prizing193514683_pr_izing
propining14310133_propining
pruning10311733_pr_uning
raiding93617593__raiding
railing83325643__railing
raising83220533__raising
ravining12269693__ravining
refraining1437263refraining
regaining112411083regaining
reining84425323__reining
remaining122212793remaining
reraising10313773reraising
restraining1247533restraining
retaining102114733retaining
retraining11310243retraining
ruining83514883__ruining
sailing83927373s__ailing
sainting93215733s__ainting
saning75127643s__a_ning
scanning113310773s_canning
scragging1435273scragging
scraiching1843793scraiching
scraighing1742933scraighing
scramming1634883scramming
scraping133310863scra_ping
scrapping1635743scrapping
scrawling15195583scrawling
screening1247193screening
scribing13238183scr_ibing
scriving14258763scr_iving
seining84020773s__eining
sequining1945323sequining
seriating10916403seriating
servicing1545343servicing
shining113816523s__hining
shrinking1735653shr_inking
shriving15268453shr_iving
skeining1347073s_keining
snailing92912973s_nailing
sopranino1143913sopra_nino
sorning83116813sor__ning
sortieing1046163sortieing
spacing123614493sp_a_cing
spading113114383sp_a_ding
spaeing103413543sp_a_eing
spalling113213463sp_alling
spamming15317603sp_amming
spanking153911973sp_anking
sparging122611133sp_arging
sparing104823873sp_a_ring
sparking152812543sp_arking
sparkling16226353sparkling
sparling112714533sp_arling
sparring113112223sp_arring
spasming13227203sp_asming
spatting113111763sp_atting
spaying133014623sp_a_ying
speaking153212493spea_king
spearing113216103spea_ring
speiling113612973sp_eiling
speiring113711263sp_eiring
spicing123914533sp__icing
spiking144312883sp__iking
spiling102919703sp__iling
spinning113310813sp_inning
spiraling1237953spira_ling
spiralling1343963spiralling
spiring103918183sp__iring
spiriting1238413spiriting
spiting103917623sp__iting
splashing1535703splashing
splatting1235983splatting
splaying14219303spla_ying
splicing1338963sp_licing
splinting1238193sp_linting
spoiling112911553sp_oiling
spooning112811443sp_ooning
spraddling1542313spraddling
sprain83614863spra__in_
sprained1138433sprain_ed
sprains93013593spra__ins
sprang95713523spra___ng
sprattling1363053sprattling
spreading1339653spreading
sprigging1435893sprigging
spring94526013spr___ing
springeing1444373spr_ingeing
springings1444663spr_ingings
sprinkling1743823spr_inkling
spritzing2135393spritzing
sprouting1236943sprouting
sprucing1336893spr_ucing
spurning11258663sp_urning
staning83922243s_ta_ning
strafing122111193stra_fing
straitening1243663straitening
stranding1149653stranding
strapping1436993strapping
strawing122411623stra_wing
straying122912693stra_ying
striating10914193striating
striding102713603str_iding
striking133012233str_iking
stringing1139753str_inging
striping112612523str_iping
striving122611393str_iving
surmising1247683surmising
surviving1644163surviving
sustaining1145883sustaining
swanning12338813s_wanning
syringing1435883syr_inging
traiking132511973_traiking
trailing92916093_trailing
trainings10246733_trainings
trining82919213_tr_ining
upbraiding1643233upbraiding
uprating11311113upra_ting
uprising1138953upr_ising

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411979.04616431.7
3Display Results1971970.0962052.1
 (SQL Overall)1786911979.59518623.3
 
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.