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

497 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
spiering11271335(None) 
speering113116321speering
speiring113711261speiring
sphering142811941sphering
spieling113212521spieling
spiring103918181spi_ring
aspiring1138872aspi_ring
peering103520352_peering
piecing12410452_piecing
pieing93917652_pie_ing
piercing1346662_piercing
sabering112113742sabering
sering74731812s__ering
severing122013852severing
sewering122411092sewering
sheering123715102sheering
shieling123512402shieling
shirring122910442shirring
shivering1637332shivering
sieging92613202s_ieging
sieving112311232s_ieving
siring75128312s_i_ring
skioring13237222skioring
skirring13297142skirring
slivering1338082slivering
sneering93414502sneering
sobering111912782sobering
spaeing103413542spae_ing
sparing104823872sp_aring
sparring113112222sparring
spearing113216102spearing
speeding122810932speeding
speeling112713122speeling
speerings12276842speerings
speiling113612972speiling
spewing133110452sp_ewing
spicing123914532spi_cing
spiffing17237082spiffing
spiking144312882spi_king
spiling102919702spi_ling
spilling113113942spilling
spinning113310812spinning
spirting112913632spirting
spiting103917622spi_ting
spitting113012322spitting
spooring113111462spooring
sporing104319412sp_oring
spring94526012sp__ring
spurring11339762spurring
steering93916792steering
stirring9299652stirring
supering11317682supering
syphering18175732syphering
tiering8315252_tiering
adhering1338883adhering
airing74927503_ai_ring
aliening91510893aliening
altering91917123altering
angering102113803angering
appearing1436893appearing
ashlering1344153ashlering
aspersing1237603asp_ersing
aspirin937823aspi_rin_
aspirins1037733aspi_rins
birring103713063_birring
bowering142911713bowering
briefing1436943briefing
capering132414963capering
cashiering1643783cashiering
catering112019913catering
cering94522533__cering
cheering143612703cheering
chirring142610173chirring
ciphering17217703ciphering
cohering142413833cohering
coppering162810893coppering
covering142215723covering
cowering142514033cowering
cyphering20175243cyphering
daikering1536103daikering
dieing84018653_die_ing
dieting93616833_dieting
dowering132510613dowering
ensphering1644973ensphering
entering91920053entering
espaliering1442693espaliering
expiring1836253expi_ring
fairing113614013fai_ring
fevering152510083fevering
firing104021723_fi_ring
fleering123811283fleering
gieing83614853_gie_ing
grieving1385893grieving
havering152211053havering
heiring113312903hei_ring
hieing104216623_hie_ing
hiring104421603_hi_ring
homering141512073homering
hovering151911143hovering
inhering12913713inhering
insphering1644193insphering
inspiring1246183inspi_ring
iring66025423__i_ring
jeering153513043_jeering
kippering18205443kippering
lagering102212313lagering
lairing83715343lai_ring
lappering14258843lappering
layering122310353layering
leering83417643_leering
levering122212503levering
lippering14217883lippering
livering122012383livering
loitering1039683loitering
loppering14237283loppering
lowering122210913lowering
metering112915633metering
miring93723803_mi_ring
mitering113015403mitering
mitring103514143_mitring
nidering10510483nidering
ochering14219393ochering
offering1536393offering
opening1039923op_ening
opiating11410093opiating
opining10311743opi_ning
ordering1039353ordering
overing111918053_overing
pairing103716733_pairing
papering132213313papering
paring94236493_p_aring
parring103222063_parring
peeing94618083_p_eeing
peeking144414953_peeking
peeling102919873_peeling
peening103318303_peening
peeping123615213_peeping
peeving135112243_peeving
peining104619153_peining
peising103416763_peising
peppering1337083peppering
perking143716463_p_erking
perming123416093_p_erming
petering112516813petering
picking163418333_picking
piecings1345343_piecings
piercings1453263_piercings
pigging123614673_pigging
piing85218833_pi__ing
piking133719643_pi_king
pilfering1536393_pilfering
piling95025593_pi_ling
pilling103722563_pilling
pimping143812123_pimping
pinging113419553_pinging
pining93726533_pi_ning
pinking143918943_pinking
pinning103417853_pinning
piperine122011833_piperine
piping114017453_pi_ping
pipping113414743_pipping
piquing1935873_piquing
pishing134314373_pishing
pissing103914803_pissing
pithing134014053_pithing
pitting103618873_pitting
pitying132910243_pitying
poring94227273_p_oring
pouring103115863_pouring
powering142210803powering
preeing103817673_preeing
preying133114553_preying
pterin81014153_pterin_
pterins9812993_pterins
purring104515823_purring
queering1838203queering
quieting18228463quieting
quiring17159993qui_ring
quivering2235873quivering
respiring12159903respi_ring
revering122918073revering
ripening1138573ripening
rogering10310273rogering
sabeing102611863sabe_ing
sabring102614843s_abring
sacring103115983s_acring
saggering12197793saggering
sailing83927373sai_ling
saining83621393sai_ning
sainting93215733sainting
savoring1269483savoring
scaring103421973s_caring
scarring112511513scarring
sceptering1545793sceptering
scheming1636633scheming
sciurine1045233sciurine
scoring103117213s_coring
scouring112810853scouring
screwing14288233screwing
scrieving1534133scrieving
scuppering1754023scuppering
searing83330923s_earing
seceding12288563seceding
secerning1246203secerning
securing11310413securing
seeding93719483s_eeding
seeing74222143s__eeing
seeking124016063s_eeking
seeling83522003s_eeling
seeming103216263s_eeming
seeping103817913s_eeping
seining84020773sei_ning
seising84018863sei_sing
seizing174114833sei_zing
serging93416673s__erging
serin55434443s__erin_
serine65432673s__erine
seringa83310743s__eringa
serins64029673s__erins
serving113014983s__erving
sewing103819623s__ewing
sexing144313893s__exing
sharing113723243s_haring
shearing123915903shearing
sheening123010803sheening
sheeting122712833sheeting
shewing143812193s_hewing
shielding1434553shielding
shielings13237123shielings
shifting152910383shifting
shilling123315383shilling
shimmering1884623shimmering
shimming16278253shimming
shining113816523shi_ning
shinning123211023shinning
shipping163611253shipping
shirking163210473shirking
shirrings13245323shirrings
shirting123213613shirting
shitting123212663shitting
shoeing113211883shoe_ing
shoring112820073s_horing
showering1646403showering
showring1548323showring
shrewing15228093shrewing
shrieking1734583shrieking
shrieving1633973shrieving
sibling10814423s_ibling
siccing12319513s_iccing
sicking143720173s_icking
sideling101012183sideling
siding83822133s_i_ding
sidling9915423s_idling
sifting113014593s_ifting
sighing123311663s_ighing
signing92713963s_igning
silking123715593s_ilking
siloing83215503s_iloing
silting83320483s_ilting
silvering1337923silvering
simmering1467823simmering
simpering1449293simpering
sinewing1267593sinewing
singing93221423s_inging
sinking123320543s_inking
sinning83918443s_inning
sintering101014803sintering
siping94220633s_i_ping
sipping123117433s_ipping
sistering101213753sistering
siting74126623s_i_ting
sitting83519633s_itting
sizing163616443s_i_zing
skeeing12308853s_keeing
skeining1347073skeining
skewering1744633skewering
skewing15318723s_kewing
skidding1535463skidding
skiing113610193ski__ing
skijoring2142623skijoring
skilling132911333skilling
skimming17286273skimming
skimping17306243skimping
skinking12299773skinking
skinning13327893skinning
skiorings14243793skiorings
skippering1943673skippering
skipping17297603skipping
skirling13249063skirling
skirting13289393skirting
skiting123812503ski_ting
skittering1535393skittering
skiving15298373ski_ving
slavering1338723slavering
sleeking133410963sleeking
sleeping113812053sleeping
sleeting93114163sleeting
sleeving12359283sleeving
slewing113311353s_lewing
slicing103514643sli_cing
slicking153712593slicking
sliding93114553sli_ding
sliming102913953sli_ming
slimming13288093slimming
slinging103312863slinging
slinking133412983slinking
sliping103314413sli_ping
slipping133510663slipping
slithering1496893slithering
slitting93012583slitting
slurring9288833slurring
smearing113511753smearing
smeeking15317833smeeking
smerking15258473s_merking
smiling103915443smi_ling
smirking15277233smirking
smiting103014443smi_ting
snaring83920953s_naring
sneezing18267053sneezing
snibbing13295893snibbing
snickering1744863snickering
snicking153610233snicking
sniffing15227453sniffing
sniggering1343763sniggering
sniping103712053sni_ping
snipping13308853snipping
sniveling1336033sniveling
snoring83917203s_noring
soaring83521893s_oaring
soiling83422323soi_ling
soldering1169033soldering
soldiering1244243soldiering
sopiting11310763sopi_ting
soring74731883s__oring
souring83219063s_ouring
spacing123614493sp_acing
spading113114383sp_ading
spaeings11276253spae_ings
spalling113213463spalling
spamming15317603spamming
spanking153911973spanking
spanning113311083spanning
sparging122611133sparging
sparking152812543sparking
sparling112714533sparling
spasming13227203spasming
spattering13107793spattering
spatting113111763spatting
spawning14296913spawning
spaying133014623sp_aying
speaking153212493speaking
speaning113512243speaning
speccing15306643speccing
specking17359733specking
speedings13265403speedings
spelling113315233spelling
spending122712433spending
spermine12311433sp_ermine
spheric14510073spheri_c
spherics1537073spherics
spherier1337783spherier
spiceries1349313spiceries
spiderier1244653spiderier
spiderish1544493spiderish
spier75728033spier___
spiered104412463spier_ed
spiers84421743spier__s
spiffying2142753spiffying
spilings11308813spi_lings
spindling13136273spindling
spinnings12294853spinnings
spiraling1237953spiraling
spirant9814293spi_rant
spirier93214073spi_rier
spirit83519923spi_ri_t
spiriting1238413spiriting
spirits94112623spi_rits
splaying14219303splaying
splicing1338963splicing
splining11310773splining
splintering1444293splintering
splinting1238193splinting
splitting1236563splitting
splurging1333623splurging
spoiling112911553spoiling
spoking143212223sp_oking
sponging1238823sponging
spoofing14228363spoofing
spooking15269803spooking
spooling113212563spooling
spooning112811443spooning
sporting112415463sporting
spotting112812093spotting
spousing11198733spousing
spouting113511953spouting
sprang95713523sp__rang
spraying14299883spraying
spreading1339653spreading
sprig85617743sp__ri_g
sprigging1435893sprigging
springe103913983sp__ringe
springing1338743springing
springs104415923sp__rings
springy13359663sp__ringy
sprint84526793sp__rint
sprinting12310033sprinting
spritzing2135393spritzing
sprucing1336893sprucing
sprung94610033sp__rung
spudding1335653spudding
spuing94313363sp__uing
spuming1248523sp_uming
spunking15258063spunking
spurning11258663spurning
spurting113111633spurting
sputtering13106463sputtering
spying123913253sp__ying
squaring18158633squaring
squiring18177563squiring
staring84527053s_taring
starring92312953starring
steeking133411353steeking
steeling93615143steeling
steeping113412583steeping
steeving12359653steeving
sterling93615553s_terling
stewing113412493s_tewing
sticking153513463sticking
stiffing15248703stiffing
stifling122110913stifling
stilling93415323stilling
stilting93312403stilting
stimying1437503stimying
stinging103213453stinging
stinking133113543stinking
stinting93415743stinting
stirrings10224693stirrings
stoppering1544613stoppering
storing83921123s_toring
strewing12289853strewing
string75327563s__tring
suberin9314563suberin_
suberins10315093suberins
subring104116263s_ubring
suckering1638103suckering
sueding92613753s_ueding
suffering1637293suffering
sugaring1039053sugaring
suiting83419003sui_ting
summering1458753summering
sundering11312323sundering
suspiring1245703suspi_ring
suturing9310373suturing
swearing123711443swearing
sweeping14389143sweeping
sweeting123911313sweeting
swerving1546113s_werving
swigging14337223swigging
swilling123511933swilling
swimming16316323swimming
swinging133411113swinging
swinking163410323swinking
swiping13319823swi_ping
swirling12249143swirling
swishing15277813swishing
swithering17105213swithering
swiveling1634573swiveling
swiving14358953swi_ving
tabering112211423tabering
tapering112112503tapering
thieving1535143thieving
tieing73518763_tie_ing
tiring74023093_ti_ring
towering122610873towering
ulcering1139333ulcering
umbering1399433umbering
umpiring1336093umpi_ring
unsphering1644283unsphering
upbearing1435033upbearing
uprearing1238373uprearing
upspring1335703upspring
uptearing1236103uptearing
ushering1258923ushering
uttering91613083uttering
veering113213683_veering
viewing1437073_viewing
viperine13189713viperine
wafering15208893wafering
wagering13219523wagering
wairing113414313wai_ring
waitering13310723waitering
watering122316323watering
wavering152410543wavering
whirring15286283whirring
wiring104521023_wi_ring
yirring11307763_yirring
zippering23215203zippering

Search took 9 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.423422437.4
2DLD Change Limit1461624977.75018859.6
3Display Results4974970.2032448.3
 (SQL Overall)1786914978.37621333.7
 
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.