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

269 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
aspiring113887(None) 
aspirin937821aspirin_
aspirins1037731aspirins
spiring103918181_spiring
admiring1236132admiring
airing74927502a__iring
aspersing1237602aspersing
aspirant1048862aspirant
aspirating1348362aspirating
assuring937772assuring
attiring939482attiring
expiring1836252expiring
inspiring1246182inspiring
respiring12159902respiring
siring75128312_s_iring
sparing104823872_sparing
speiring113711262_speiring
spicing123914532_spicing
spiering112713352_spiering
spiking144312882_spiking
spiling102919702_spiling
spirting112913632_spirting
spiting103917622_spiting
sporing104319412_sporing
spring94526012_sp_ring
suspiring1245702suspiring
umpiring1336092umpiring
abiding11510503a_biding
abjuring1834883abjuring
abscising1444943abscising
abseiling1265343abseiling
acquiring2144483acquiring
adhering1338883adhering
adjuring1735103adjuring
admixing1944133admixing
adoring9412523a_doring
advising1336153advising
affirming1843103affirming
affixing2264333affixing
agnizing1936833agnizing
aiding84423613a__iding
ailing74331013a__iling
aiming94320843a__iming
airings83913843a__irings
airting83616303a__irting
alining81917043a_lining
alluring939073alluring
altering91917113altering
amping114317573amp__ing
anearing9413973anearing
angering102113803angering
answering1345803answering
antiking13412073antiking
anviling1239743anviling
aping87327233a_p__ing
appearing1436893appearing
applying1634653applying
apposing1337403apposing
apprising1447963apprising
apprizing2347193apprizing
arising83619973a_rising
armoring1149123armoring
arriving1237363arriving
ascribing1444953ascribing
ashing107824093as__hing
ashlaring1344493ashlaring
ashlering1344153ashlering
asinine7310723as_inine
asking116017233as__king
asperating1349563asperating
asperity1347223asperity
aspirants1145233aspirants
aspirata1054993aspirata
aspirate1039943aspirate
aspire8612123aspir__e
aspired1068173aspir_ed
aspirer967903aspir_er
aspirers1066493aspirers
aspires9612043aspir_es
assailing1036023assailing
assaying1236003assaying
asserting1038663asserting
assigning1144673assigning
assisting1046183assisting
assoiling1045353assoiling
assorting1037303assorting
assuming1135143assuming
astringe938223as_tringe
auditing1039033auditing
auguring1036383auguring
availing1267283availing
averring12239063averring
avoiding1336783avoiding
awaiting1238273awaiting
bagpiping1741913bagpiping
bemiring13239603bemiring
capering132414963capering
capsizing2345833capsizing
cashiering1643783cashiering
chairing143110773chairing
choiring14279793choiring
conspiring1546553conspiring
dayspring1642613daysp_ring
deairing10311893deairing
desiring10312143desiring
despairing1445063despairing
despising13167503despising
despiting13179323despiting
espying1336193esp_ying
esquiring19174023esquiring
fairing113614013_fairing
firing104021723__firing
gasping113714363gasp__ing
glairing1047283glairing
hampering1738863hampering
hasping134414903hasp__ing
heiring113312903_heiring
hiring104421603__hiring
impairing1445473impairing
iring66025423___iring
kashering1736253kashering
lairing83715343_lairing
lappering14258843lappering
mastering122315303mastering
miring93723803__miring
misfiring1536973misfiring
opining10311743_opining
pairing103716733_pairing
pampering1638383pampering
papering132213313papering
paring94236493__paring
pastoring12310853pastoring
pasturing1238433pasturing
paupering1437273paupering
perspiring1544853perspiring
pieing93917653__pieing
piing85218833__pi_ing
piking133719643__piking
piling95025593__piling
pining93726533__pining
piping114017453__piping
poring94227273__poring
quiring17159993_quiring
rasping104316253rasp__ing
refiring123513923refiring
rehiring122911883rehiring
repairing12310013repairing
repining114116593repining
respiting121912863respiting
respring111614063resp_ring
retiring92717413retiring
rewiring122911223rewiring
sabering112113743sabering
sabring102614843_sabring
sacring103115983_sacring
sailing83927373_sailing
saining83621393_saining
sapling103217863sap_ling
sapping123519313sap_ping
savoring1269483savoring
scaring103421973_scaring
scoring103117213_scoring
searing83330923_searing
seining84020773_seining
seising84018863_seising
seizing174114833_seizing
sering74731813_s_ering
sharing113723243_sharing
shining113816523_shining
shirking163210473_shirking
shirring122910443_shirring
shirting123213613_shirting
shoring112820073_shoring
siding83822133_s_iding
siping94220633_s_iping
sipping123117433_sipping
siting74126623_s_iting
sizing163616443_s_izing
skiing113610193_ski_ing
skioring13237223_skioring
skirling13249063_skirling
skirring13297143_skirring
skirting13289393_skirting
skiting123812503_skiting
skiving15298373_skiving
slicing103514643_slicing
sliding93114553_sliding
sliming102913953_sliming
sliping103314413_sliping
smiling103915443_smiling
smirking15277233_smirking
smiting103014443_smiting
snaring83920953_snaring
sniping103712053_sniping
snoring83917203_snoring
soaring83521893_soaring
soiling83422323_soiling
sopiting11310763sopiting
soring74731883_s_oring
souring83219063_souring
spacing123614493_spacing
spading113114383_spading
spaeing103413543_spaeing
sparging122611133_sparging
sparking152812543_sparking
sparling112714533_sparling
sparring113112223_sparring
spaying133014623_spaying
spearing113216103_spearing
speering113116323_speering
speiling113612973_speiling
spewing133110453_spewing
sphering142811943_sphering
spieling113212523_spieling
spiffing17237083_spiffing
spilings11308813_spilings
spilling113113943_spilling
spinning113310813_spinning
spiraling1237953_spiraling
spirant9814293_spirant
spirier93214073_spirier
spirit83519923_spiri_t
spiriting1238413_spiriting
spirits94112623_spirits
spitting113012323_spitting
splicing1338963_splicing
splining11310773_splining
spoiling112911553_spoiling
spoking143212223_spoking
spooring113111463_spooring
sporting112415463_sporting
sprang95713523_sp_rang
sprig85617743_sp_ri_g
springe103913983_sp_ringe
springs104415923_sp_rings
springy13359663_sp_ringy
sprint84526793_sp_rint
sprung94610033_sp_rung
spuing94313363_sp_uing
spuming1248523_spuming
spurning11258663_spurning
spurring11339763_spurring
spurting113111633_spurting
spying123913253_sp_ying
squiring18177563squiring
staring84527053_staring
stirring9299653_stirring
storing83921123_storing
string75327563_s_tring
subring104116263_subring
suiting83419003_suiting
supering11317683supering
swiping13319823_swiping
swirling12249143_swirling
swiving14358953_swiving
tampering1438453tampering
tapering112112503tapering
tiring74023093__tiring
transpiring1446873transpiring
unpiling1139753unpiling
unsparing1237713unsparing
untiring9312003untiring
uppiling1335853uppiling
upsizing2035413upsizing
upspring1335703upspring
ushering1258923ushering
vaporing1437653vaporing
wairing113414313_wairing
wiring104521023__wiring

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622697.37319824.0
3Display Results2692690.1102445.5
 (SQL Overall)1786912697.88922650.7
 
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.