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

536 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
sprains9301359(None) 
sprain83614861sprain_
strains74218151strains
brains85125472_brains
drains73719402_drains
grains74223092_grains
pains75138282_p_ains
plains85019592_plains
prawns11509022_prawns
rains55140232__rains
sains55639972s__ains
sarans64224432sara_ns
sarins63932622sar_ins
serails73318362serails
serais64326132serai_s
sereins73716122sereins
serins64029672ser_ins
spails84817822sp_ails
spaits85017472sp_aits
spans74528732sp_a_ns
sparids103512122sparids
sparing104823872sparing
spavins12419322spavins
spawns11577922sp_awns
speans85417142spea_ns
spins75327982sp__ins
sprags95715822spra_gs
sprained1138432sprained
sprang95713522spra_ng
sprangs104610052sprangs
sprats85819932spra_ts
sprawls12176372sprawls
spraying14299882spraying
sprays115913642spra_ys
sprigs94814772spr_igs
spring94526012spr_ing
springs104415922spr_ings
sprint84526792spr_int
sprints94113772spr_ints
sprits85122532spr_its
stains64923652s_tains
strain64919572strain_
straits74916322straits
swains94513952s_wains
trains64725342_trains
acrasins1039973acrasins
ains46158883___ains
apraxias1746333apraxias
aprons8316993apr_ons
arraigns944353arraigns
aspirins1037733aspirins
attains7310983attains
bargains1178643bargains
berlins93216013berlins
blains84516373_blains
braids95015693_braids
brails84621293_brails
brain76229383_brain_
brainy114815643_brainy
brans75437433_bra_ns
brawns115614083_brawns
brins75533973_br_ins
bruins86014953_bruins
burans85019303bura_ns
burins84221893bur_ins
cains75334303__cains
captains121810573captains
carabins12312363carabins
carlins93921913carlins
ceratins102818733ceratins
chains114819703_chains
cocains111313923cocains
cortins92421333cortins
curtains10259703curtains
cyprians1544213cyprians
deraigns1034883deraigns
derails84216393derails
detains83716093detains
detrains9411763detrains
distrains10411333distrains
domains10510873domains
dormins10311273dormins
drails74716953_drails
drain65222893_drain_
durians839573durians
elains64919853_elains
engrains937583engrains
entrains8312963entrains
esprits938393espr_its
estrins7315853estr_ins
explains1766443explains
firkins1437663firkins
frails93716473_frails
furans94515953fura_ns
fusains1038363fusains
gains65729513__gains
gradins93416233_gradins
grails77518783_grails
grain65126253_grain_
grainy103914213_grainy
grans64832543_gra_ns
gratins84119183_gratins
grins65427223_gr_ins
groins73917203_groins
harmins123716723harmins
harpins123615703harpins
heparins13310123heparins
heroins103518013heroins
ingrains948983ingrains
jerkins18358253jerkins
kains96125643__kains
keratins122313483keratins
kraits104912203_kraits
lorans65117603lora_ns
mains75635113__mains
margins103815193margins
marlins93420473marlins
martins93322063martins
merlins93015813merlins
mirins83918903mir_ins
mistrains11511353mistrains
moraine9314573moraine
moraines10314363moraines
mureins9310733mureins
murrains1036853murrains
obtains939163obtains
opsins8411713op_sins
orcins83313433_orcins
ordains879653ordains
orpins83614163_orpins
paiks114719853_p_aiks
pails75833063_p_ails
pain65647243_p_ain_
paint75443693_p_aint
paints85921833_p_aints
pairs75325833_p_airs
pans65855733_p_a_ns
papains11312363papains
parians93519733_parians
paries84742513_paries
paring94236493_paring
parings104219213_parings
paris75145943_pari_s
patins87528783_patins
pavins114919663_pavins
pawns108818133_p_awns
peans75437643_pea_ns
peins76128063_p_eins
pekins121812233_pekins
pertains102113423pertains
pians75126963_pia_ns
pins65558453_p__ins
plaids94312443_plaids
plain74823303_plain_
plaint85323203_plaint
plaints94012053_plaints
plaits83816473_plaits
plans75731273_pla_ns
praams10459643_praams
prahus11458243_prahus
praise84419413_praise
praises94121103_praises
prajna1535073_prajna
prajnas1635453_prajnas
praline93019743_praline
pralines102217723_pralines
prams96125513_pra_ms
prang84820323_pra_ng
prangs94816233_prangs
prank115019453_pra_nk
pranks124814723_pranks
praos74923563_pra_os
prases84429023_prases
prates84633163_prates
prating103424453_prating
prats76333393_pra_ts
praus74621753_pra_us
prawn105312433_prawn_
praxes156215183_praxes
praxis154012253_praxis
praying133717323_praying
prays105022433_pra_ys
preens85020113_preens
pries74339533_pr_ies
prigs85219703_pr_igs
prims95425933_pr_ims
prink114719673_pr_ink
prinks124315383_pr_inks
print74837463_pr_int
prints84320103_pr_ints
prions84317783_prions
priss74623893_pr_iss
prying124114803_prying
purins83722653_purins
purlins93415423purlins
pyins105815863_p_yins
pyrans11411063pyra_ns
raias54631123__raias
raids65827513__raids
rails55937403__rails
rain46251733__rain_
rainy85921083__rainy
rais45252623__rai_s
ranis55235833__ranis
ravins94622563__ravins
rawins95617623__rawins
refrains1139593refrains
regains84316583regains
reins56234563__reins
remains94117913remains
restrains9311623restrains
retains74522253retains
retrains8314533retrains
rins46153193__r_ins
ruins55822033__ruins
sabins85521983s_abins
safranins1244353safranins
saids65328853s__aids
sails55738103s__ails
saimins9312113saimins
sain45551293s__ain_
saint55147073s__aint
saints65122423s__aints
sans45153363s__a_ns
saponins1039453saponins
saran53730303sara_n_
sarapes94617743sarapes
sarcina9310733sarcina
sarcinas1039273sarcinas
sardine83317393sardine
sardines92815563sardines
sardius839553sardius
sarin55239253sar_in_
saris54544953sar_i_s
sarsens7311393sarsens
sasins64923103s_asins
satins64930483s_atins
saurians837763saurians
savarins1139893savarins
savins93923133s_avins
scans74625103s_ca_ns
scaring103421973scaring
scrags95713803scra_gs
scraich1436763scraich
scraichs1543993scraichs
scraigh1335673scraigh
scraighs1443633scraighs
scrams105216623scra_ms
scrapes116217663scrapes
scrapies124612473scrapies
scraping133310863scraping
scrapings14255173scrapings
scraps106017243scra_ps
scrawls12177283scrawls
scrawny15213943scrawny
screens95212183screens
scries85226823scr_ies
scrims104615933scr_ims
scrips105316033scr_ips
scrying1338663scrying
searing83330923searing
seatrains947603seatrains
sedans74816093seda_ns
seisins73614393seisins
seizins164010133seizins
sequins1637863sequins
seracs84418573sera_cs
serai56830163serai__
serail64222673serai_l
serapes95218103serapes
seraphs12408093seraphs
serein63318463serein_
serging93416673serging
sergings10299213sergings
serials73919743serials
sericins10312463sericins
series64540973ser_ies
serifs94017053ser_ifs
serin55434443ser_in_
serine65432673ser_ine
serines74229543ser_ines
sering74731813ser_ing
sermons9311783sermons
serries73925353serries
serving113014983serving
servings12249223servings
sewans95215903sewa_ns
sextains15246813sextains
shairns10276783s_hairns
sharias102516003sharias
sharifs13279903sharifs
sharing113723243sharing
sharns95516983s_harns
shins85131043s__hins
shorans102812413shora_ns
shrank13359123shra_nk
shrine94920053shr_ine
shrines104618693shr_ines
shrink134511733shr_ink
shrinks14397913shr_inks
shris84221453shr_i_s
simians959203simians
simlins9311843simlins
sins46755273s___ins
sirens65318153sir_ens
siring75128313sir_ing
sirloins836723sirloins
siskins1159583siskins
skeans104512913skea_ns
skeins103911903s_keins
skins94723463s__kins
slain54923573s_lain_
snails64816653s_nails
snaring83920953snaring
soaring83521893soaring
soarings93210393soarings
solanins8310513solanins
solans64122493sola_ns
somans84619303soma_ns
soprani937403sopra_ni
sopranino1143913sopranino
sopraninos1251983sopraninos
soprano937003sopra_no
sopranos1046433sopranos
soras55041013sora__s
sorbing102815263sorbing
sordine82515233sordine
sordines92414073sordines
sordini8228963sordini
sordino8219443sordino
soring74731883sor_ing
sorings83817253sor_ings
sorning83116813sorning
sorns55028423sor__ns
sorties74126403sorties
sorting83221813sorting
sovrans1036483sovra_ns
sowans94215893sowa_ns
sozins15510793s_ozins
spaces104722633sp_aces
spacing123614493spacing
spacings13287043spacings
spades94222583sp_ades
spading113114383spading
spaeing103413543spaeing
spaeings11276253spaeings
spaes76029973sp_a_es
spahis11310383sp_ahis
spail74921553sp_ai_l
spait75631603sp_ai_t
spales84728103sp_ales
spalls84217343sp_alls
spams94922193sp_a_ms
span65234663sp_a_n_
spang84919733sp_a_ng
spank115919573sp_a_nk
spanks124514123sp_anks
sparers94519613sparers
spares84834553sp_ares
sparges104016343sparges
sparging122611133sparging
sparid94016933spari_d
sparking152812543sparking
sparks124616363sp_arks
sparling112714533sparling
sparlings12257153sparlings
sparoids11218713sparoids
sparring113112223sparring
spars75431543sp_a_rs
spartina1037983spartina
spartinas1135793spartinas
spas67036723sp_a__s
spasms10418973sp_asms
spates85028173sp_ates
spats75031383sp_a_ts
spavies123012943spavies
spavin114210653spavin_
spawn107811713sp_awn_
spaying133014623spaying
spays105520513sp_a_ys
speaking153212493speaking
speakings16345933speakings
speaks125114583spea_ks
spean74620513spea_n_
speaning113512243speaning
spearing113216103spearing
spears84019473spea_rs
species11314133species
speils84116223sp_eils
speirs85013233sp_eirs
speiss84311643sp_eiss
spermine12311433spermine
spermines13310543spermines
spewing133110453spewing
sphinx1866203sp_hinx
spicing123914533spicing
spics94123243sp__ics
spies76037623sp__ies
spiking144312883spiking
spiks114117473sp__iks
spiling102919703spiling
spilings11308813spilings
spin66231303sp__in_
spine76534423sp__ine
spines85132033sp__ines
spiny104921303sp__iny
spiraeas10286233spiraeas
spiraling1237953spiraling
spirals93212513spira_ls
spirant9814293spira_nt
spirants1088283spirants
spiring103918183spiring
spirits94112623spirits
spirting112913633spirting
spiting103917623spiting
spits74429553sp__its
spivs105114243sp__ivs
splakes1349673splakes
splats84817303spla_ts
splaying14219303splaying
splays114910873spla_ys
spleens937103spleens
spline86020533sp_line
splines94718893sp_lines
splint85223283sp_lint
splints94511743sp_lints
splits85416413sp_lits
spoils84614533sp_oils
spoking143212223spoking
spongins1136563spongins
spoons84116023sp_oons
sporing104319413sporing
sporrans1045523sporrans
sporting112415463sporting
sprag86418693spra__g
spraining1248153spraining
sprat76635973spra__t
sprawl11188063spra_wl
sprawling15175123sprawling
sprawly15166043sprawly
spray106720063spra__y
sprayed13398903sprayed
sprayer12369043sprayer
sprayers13367053sprayers
spreading1339653spreading
spreads1039763spreads
sprees85620643spr_ees
sprent84522383spr_ent
sprier84119063spr_ier
spriest92718643spr_iest
sprig85617743spr_i_g
springe103913983spr_inge
springes114014033spr_inges
springy13359663spr_ingy
sprit76736403spr_i_t
sprite84421773spr_ite
sprites94220333sprites
spritz174714423spr_itz
sprouts949983sprouts
spruces113810503spruces
sprucing1336893sprucing
sprues84515763spr_ues
sprugs94010173spr_ugs
sprung94610033spr_ung
spuing94313363sp_uing
spuming1248523spuming
spurning11258663spurning
spurns84811383sp_urns
spurries102311323spurries
spurring11339763spurring
spurting113111633spurting
spying123913253sp_ying
sris45434153s_r_i_s
staigs75414813s_taigs
stain55727943s_tain_
stairs65416333s_tairs
staring84527053staring
statins73719773statins
stearins8312143stearins
steins64818343s_teins
stotins73213873stotins
strafes104516003strafes
strafing122111193strafing
strained9412253strained
strainer8512223strainer
strainers9510383strainers
strait64025893strai_t
straitens946233straitens
strakes114218073strakes
strand74514823stra_nd
strands83711953strands
strang75718313stra_ng
straps87721783stra_ps
strass67117223stra_ss
stratas73013583stratas
straths102711723straths
stratus73011733stratus
strawing122411623strawing
straws98718673stra_ws
straying122912693straying
strays96417933stra_ys
string75327563str_ing
strings84617133str_ings
strips85719653str_ips
surahs94515543sura_hs
suras55336333sura__s
surfing112914483surfing
surfings12268073surfings
surging93115433surging
sustains838553sustains
suzerains1845733suzerains
swails94913123s_wails
swain84919053s_wain_
swans84625013s_wa_ns
sylvins13246243sylvins
syrens94911993syr_ens
syrinx1637143syr_inx
tains54936323__tains
terais64023513terai_s
terrains8410323terrains
traiks104013713_traiks
trails64622513_trails
train56529113_train_
traits65121983_traits
trans54933043_tra_ns
twains95811183_twains
upbraids1343553upbraids
upraise9158603upraise
upraises10188473upraises
uprates93814863uprates
uprating11311113uprating
verdins112812333verdins
vervains1435293vervains
virgins1137863virgins
vitrains1138283vitrains
wains86930873__wains

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 Filter1786911340270.406440125.6
2DLD Change Limit1340275366.83019623.3
3Display Results5365360.1862881.7
 (SQL Overall)1786915367.42224075.9
 
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.