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

419 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
sprangs10461005(None) 
prangs94816231_prangs
sprags95715821spra_gs
sprang95713521sprang_
springs104415921springs
orangs74116032_orangs
ourangs8318502ourangs
pangs84628662_p_angs
parangs104314372parangs
prang84820322_prang_
pranks124814722_pranks
prongs94314482_prongs
sarans64224432saran_s
sarongs84511802sarongs
satangs8479712satangs
scrags95713802scra_gs
slangs75615342s_langs
sopranos1046432sopranos
sorings83817252sorings
spang84919732sp_ang_
spanks124514122sp_anks
spans74528732sp_an_s
speans85417142spean_s
spirants1088282spirants
sprag86418692spra_g_
sprains93013592sprains
sprats85819932spra_ts
sprawls12176372sprawls
sprays115913642spra_ys
sprigs94814772spr_igs
spring94526012spring_
springe103913982springe
springes114014032springes
springy13359662springy
sprints94113772sprints
sprugs94010172spr_ugs
sprung94610032sprung_
stangs75018162s_tangs
strands83711952strands
strang75718312strang_
strange85416342strange
stranges94516762stranges
strings84617132strings
wrangs104611912_wrangs
airings83913833airings
aprons8316993apron_s
arrange838683arrange
arranges939413arranges
aspirants1145233aspirants
bangs85627773__bangs
barongs105310833barongs
bhangs12449663_bhangs
boranes93720403boranes
borings103614243borings
brags85625103_bra_gs
brands95118943_brands
branks124817383_branks
brans75437433_bran_s
brants85723053_brants
brings94618433_brings
burans85019303buran_s
changs125215373_changs
clangs95113613_clangs
crags85622573_cra_gs
cranes84330753_cranes
cranks125015313_cranks
dangs75623203__dangs
darings93713643darings
defangs1235363defangs
derange939813derange
deranges1039973deranges
drags75521113_dra_gs
earings84517703earings
errands847583errands
errants7410623errants
estrange9488893estrange
estranges10359983estranges
fangs96224073__fangs
firings114112323firings
frags96322163_fra_gs
francs114112193_francs
franks134912733_franks
furanes103214863furanes
furans94515953furan_s
gangs76222573__gangs
gobangs11385833gobangs
grands84218243_grands
grange83716203_grange
granges93516523_granges
grans64832543_gran_s
grants73722473_grants
hangs95726723__hangs
jurants14379213jurants
kiangs11378363_kiangs
liangs74410593_liangs
lorans65117603loran_s
operands1146813operands
operants1039483operants
orang65119943_orang_
orange74016323_orange
oranges84215333_oranges
orangy105111233_orangy
ourang73311063ourang_
panes76148693_p_anes
pang75336283_p_ang_
panga85323533_p_anga
pangas99921103_p_angas
pans65855723_p_an_s
pants76536923_p_ants
parang93715513parang_
parings104219213parings
peags86122843_pea_gs
peans75437643_pean_s
penangs10268373penangs
pianos84315933_pianos
pians75126963_pian_s
pinangs10267793pinangs
pings85830883_p_ings
piranas9912603piranas
planes85028083_planes
planks124116753_planks
plans75731273_plan_s
plants84921803_plants
pongs85526343_p_ongs
praams10459643_praams
prahus11458243_prahus
prajnas1635453_prajnas
prams96125513_pra_ms
prance104318573_prance
prances113618773_prances
pranged114512553_pranged
prank115019453_pran_k
praos74923563_pra_os
prases84429023_prases
prates84633163_prates
prats76333393_pra_ts
praus74621753_pra_us
prawns11509023_prawns
praxes156215183_praxes
praxis154012253_praxis
prays105022433_pra_ys
prigs85219703_pr_igs
prinks124315383_prinks
prints84320103_prints
probangs13256203_probangs
progs86624153_pr_ogs
prong85218113_prong_
prunes83419063_prunes
prunus8399363_prunus
pungs85422223_p_ungs
puranas9712643puranas
pyrans11411063pyran_s
raggs75216473__raggs
rags55448373__ra_gs
rands65930453__rands
rang56939153__rang_
range64728413__range
ranges73826923__ranges
rangy95320383__rangy
ranis55235833__ranis
ranks95225733__ranks
rants55935343__rants
rehangs1137563rehangs
resprang11175843resprang_
resprings12156253resprings
rings65029173__rings
rungs611819403__rungs
sacrings11278923sacrings
sags55948403s__a_gs
sands65228583s__ands
sanes55649073s__anes
sang55441223s__ang_
sanga66023793s__anga
sangas75222653s__angas
sangh95517453s__angh
sanghs105312063s__anghs
sans45153353s__an_s
saplings11269803saplings
saran53730303saran__
sarapes94617743sarapes
sardanas937813sardanas
sarins63932623sarin_s
sarong73914873sarong_
satang75711563satang_
savants1038653savants
savings114412953savings
sayings113610833sayings
scags85520973s_ca_gs
scans74625103s_can_s
scants85219723s_cants
scrag85916173scra_g_
scraggy14304583scraggy
scraigh1335673scraigh
scraighs1443633scraighs
scrams105216623scra_ms
scrapes116217663scrapes
scrapings14255163scrapings
scraps106017243scra_ps
scrawls12177273scrawls
secants93413893secants
sedans74816093sedan_s
seeings84411293seeings
seracs84418573sera_cs
serails73318363serails
serais64326133sera_is
serapes95218103serapes
seraphs12408093seraphs
serenes73222903serenes
sergings10299203sergings
serines74229543serines
sering74731813sering_
seringa83310743seringa
seringas9339003seringas
serins64029673serin_s
serranos857843serranos
servants1137993servants
servings12249213servings
sewans95215903sewan_s
sewings11369173sewings
shags95123863s_ha_gs
shanks135315583s_hanks
sharns95516983sharn_s
shebangs1443593shebangs
shorans102812403shoran_s
shorings12269483shorings
shrank13359123shran_k
shrines104618693shrines
shrinks14397913shrinks
shrugs10469163shr_ugs
siamangs1144053siamangs
sidings94011453sidings
silanes72517163silanes
sings65532703s__ings
sirens65318153siren_s
siring75128313siring_
sizings17378013sizings
skags104316073s_ka_gs
skanks94710833s_kanks
skeanes113610713skeanes
skeans104512913skean_s
skiings12295733skiings
slags66525903s_la_gs
slang66324023s_lang_
slangy105411393s_langy
slants64819083s_lants
slings74618013s_lings
snags64421313s_na_gs
soarings93210393soarings
solands84412343solands
solanos74412853solanos
solans64122493solan_s
somans84619303soman_s
sonants7511233sonants
songs67725553s__ongs
soprani937403sopran_i
soprano937003sopran_o
soras55041013sora__s
soring74731883soring_
sorns55028413sor_n_s
sovrans1036483sovran_s
sowans94215893sowan_s
spaces104722633sp_aces
spacings13287043spacings
spades94222583sp_ades
spaeings11276253spaeings
spaes76029973sp_a_es
spahis11310383sp_ahis
spails84817823sp_ails
spaits85017473sp_aits
spales84728103sp_ales
spalls84217343sp_alls
spams94922193sp_a_ms
span65234663sp_an__
spangle1038403sp_angle
spangles1138893sp_angles
spangly1336473sp_angly
spank115919573sp_an_k
sparers94519613sparers
spares84834553sp_ares
sparge94216043sp_arge
sparges104016333sparges
sparids103512123sparids
sparing104823873sparing_
sparks124616363sp_arks
sparlings12257143sparlings
spars75431543sp_a_rs
spas67036723sp_a__s
spasms10418973sp_asms
spates85028173sp_ates
spats75031383sp_a_ts
spawns11577923sp_awns
spays105520513sp_a_ys
speakings16345923speakings
speaks125114583spea_ks
spean74620513spean__
speaned103411523speaned
spears84019473spea_rs
speerings12276833speerings
spends94714473sp_ends
sphenes123013163sphenes
sphinges14267483sphinges
spilings11308813spilings
spinage10289653spinage
spinages11289293spinages
spinals93911863spinals
spines85132033sp_ines
spins75327983sp_in_s
spiraeas10286233spiraeas
spirals93212513spira_ls
spirant9814293spiran_t
spiring103918183spiring_
splakes1349673splakes
splats84817303spla_ts
splays114910873spla_ys
splents93912133splents
splines94718893splines
splints94511743splints
sponge939663sp_onge
sponges10311043sp_onges
spongy1236743sp_ongy
spoons84116013spoon_s
sporangia1243493sporangia
sporing104319413sporing_
sporrans1045523sporran_s
sprain83614863spra_in
sprained1138433sprained
sprat76635973spra__t
sprawl11188063spra_wl
sprawly15166043sprawly
spray106720063spra__y
sprayed13398903sprayed
sprayer12369043sprayer
sprayers13367053sprayers
spraying14299883spraying_
spreads1039763spreads
sprees85620643spr_ees
sprent84522383spren_t
sprig85617743spr_ig_
spriggy14374213spriggy
springal1145973springal
springals1245373springals
springed123911313springed
springer113311753springer
springers12309983springers
sprint84526793sprin_t
sprites94220333sprites
sprits85122533spr_its
sprouts949983sprouts
spruces113810503spruces
sprues84515763spr_ues
sprug85313893spr_ug_
spryness1334003spryness
spuing94313363spuing_
spunks12349333sp_unks
spurns84811383spurn_s
spying123913253spying_
stags66226743s_ta_gs
staigs75414813s_taigs
stands75118053s_tands
stanes64933403s_tanes
stang66424683s_tang_
stanks104917703s_tanks
stings76220183s_tings
strafes104515993strafes
strains74218153strains
straits74916323straits
strakes114218073strakes
strand74514823stran_d
stranger94715093stranger
strangers104112153strangers
strangest103210843strangest
strangle98411503strangle
strangles103011553strangles
straps87721783stra_ps
strass67117223stra_ss
stratas73013573stratas
straths102711713straths
stratus73011723stratus
straws98718673stra_ws
strays96417933stra_ys
string75327563string_
stringy114111073stringy
strong74914883strong_
strung75213023strung_
strunts7429543strunts
subrings11229883subrings
surahs94515543sura_hs
suras55336323sura__s
surfings12268073surfings
swags94921253s_wa_gs
swang95519723s_wang_
swanks134811563s_wanks
swans84625013s_wan_s
swings104714453s_wings
syrens94911993syren_s
syringa11366353syringa
syringas12285953syringas
syringe11349473syringe
syringes122810213syringes
tangs65028343__tangs
throngs11508163throngs
tranks104017763_tranks
tranqs155210313_tranqs
trans54933043_tran_s
twangs10358093_twangs
tyrants1037453tyrants
unhangs1136203unhangs
uplands1036943uplands
uppings12257123uppings
uprates93814863uprates
upsprang1342083upsprang_
upsprings1442703upsprings
vangs96319583__vangs
whangs13439723_whangs
wirings113910103wirings
wrang94716113_wrang_
wrings104012973_wrings
wrongs10338933_wrongs
yangs95618693__yangs

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340274195.75023309.0
3Display Results4194190.1432930.1
 (SQL Overall)1786914196.03329618.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.