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

143 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
unsparing123771(None) 
ensnaring1046382ensnaring
insnaring1046312insnaring
inspiring1246182inspiring
sparing104823872__sparing
unbearing1239352unbearing
uncaring11312842un_caring
undaring10412752un_daring
unfearing1338882unfearing
unpaying1456942un_paying
unsaying1288152uns_aying
unsealing10711042unsealing
unseaming1278112unseaming
unseating10713202unseating
unsnarling1143912unsnarling
unsparingly1753532unsparingly
unspeaking1744422unspeaking
unsphering1644282unsphering
unsprung1143172unsp_rung
unstating10711212unstating
unstring9312092uns_tring
unswearing1444412unswearing
upsoaring1244512upsoaring
upspring1335702upsp_ring
upstaring1235962upstaring
anearing9413973an_earing
answering1345803answering
aspiring1138873_aspiring
comparing162410583comparing
conspiring1546553conspiring
despairing1445063despairing
disparting1438933disparting
endearing1139323endearing
enslaving1345383enslaving
ensnarling1143223ensnarling
ensphering1644973ensphering
ensuring9310173ens_uring
inspanning1343203inspanning
insphering1644193insphering
instarring1144063instarring
instating10812213instating
insuring9311153ins_uring
mispaging1537803mispaging
misparsing1546613misparsing
misparting1538083misparting
nearing83020333_n_earing
outsoaring1137703outsoaring
outspring1238903outsp_ring
outstaring1137803outstaring
paring94236493___paring
preparing14311643preparing
respacing1438893respacing
respading1338803respading
respiring12159903respiring
respring111614063resp_ring
scaring103421973__scaring
searing83330923__searing
sharing113723243__sharing
snaring83920953__snaring
soaring83521893__soaring
spacing123614493__spacing
spading113114383__spading
spaeing103413543__spaeing
sparging122611133__sparging
sparking152812543__sparking
sparling112714533__sparling
sparring113112223__sparring
spaying133014623__spaying
spearing113216103__spearing
spiring103918183__spiring
sporing104319413__sporing
spring94526013__sp_ring
staring84527053__staring
suspiring1245703suspiring
umpiring1336093u_mpiring
unabating1246753unabating
unaging9510933un__aging
unarming1138623un__arming
unbaling11310683un_baling
unbarring1236063unbarring
unbracing1437023unbracing
unbraking1636933unbraking
uncaging1268713un_caging
uncaking1539463un_caking
uncapping1635133uncapping
uncasing11511003un_casing
unceasing1239653unceasing
unchairing1644603unchairing
uncharging1744393uncharging
uncharming1844523uncharming
uncoating12611923uncoating
uncrating12813183uncrating
undraping1337333undraping
undrawing1436903undrawing
unerring9311273un_erring
unfading1347693un_fading
ungazing1936033un_gazing
unguarding1343533unguarding
unhairing1335953unhairing
uninspiring1451953uninspiring
unlacing1148643un_lacing
unlading1058863un_lading
unlaying1258363un_laying
unleading1138673unleading
unlearning1144713unlearning
unloading1137193unloading
unmaking1538133un_making
unmeaning1237953unmeaning
unmitring1245263unmitring
unmooring1255813unmooring
unpacking1835133un_packing
unpiling1139753un_piling
unquaking2354593unquaking
unseeing988293uns_eeing
unselling10810333unselling
unsetting1088993unsetting
unsewing1287433uns_ewing
unsexing1686853uns_exing
unsling8313643uns__ling
unsmiling1256873unsmiling
unsnagging1342953unsnagging
unsnapping1542933unsnapping
unspooling1343853unspooling
unstacking1744993unstacking
unstartling1242383unstartling
unstrings1046013uns_trings
unstrung954653uns_trung
unswathing1743303unswathing
unswerving1743043unswerving
untiring9312003un_tiring
unvarying1644503un_varying
unwaning1238133un_waning
unweaving1636133unweaving
upbearing1435033upbearing
uprearing1238373uprearing
upscaling1444653upscaling
upsprang1342083upsp_rang
upsprings1442703upsp_rings
upsprung1341703upsp_rung
upstaging1344113upstaging
upstarting1343883upstarting
uptearing1236103uptearing
ushering1258923u_shering

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 Filter1786911486410.1531167915.0
2DLD Change Limit1486411436.75322011.1
3Display Results1431430.0602383.3
 (SQL Overall)1786911436.96625651.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.