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

124 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
spirally134802(None) 
spinally1338021spinally
apically1539832apically
epically15310582epically
serially11912842serially
spiracle1255802spiracle
spiral83715342spira_l_
spiraled1137732spiraled
spirality1446432spirality
spiralled1244402spiralled
spirals93212512spira_ls
spirilla1045072spirilla
sprawly15166042sp_rawly
virally1339652_virally
aborally1347063aborally
aerially11911913aerially
amorally1348093amorally
animally1368643animally
astrally1148883astrally
aurally10310543_aurally
axially1737233axi_ally
bridally1446453bridally
capitally1646663capitally
chorally1638103chorally
clinally1347233clinally
coitally1339483coitally
finally13310103_finally
florally1447033florally
gyrally1435583_gyrally
jurally1736963_jurally
laically1338983laically
misally121111063_misally
morally12411493_morally
neurally1137933neurally
operably1557093operably
optically1649903optically
optimally1644563optimally
orally93113593__orally
osmically1647323osmically
pally105727123_p__ally
papally1437973_papally
penally121111773_penally
piracy1339473_pira_cy
plurally1345813plurally
rally84725903___rally
retrally11310523retrally
rurally1038303_rurally
sally85129713s___ally
scrawly15197193s_crawly
seminally1458803seminally
separably1655773separably
severally1546243severally
sexually1845603sexually
shrilly13318563s_hrilly
signally1246533signally
silly84527623s_i__lly
sizably2136613s_izably
smirkily1753333smirkily
socially1338543socially
sonically14310953sonically
sororally1246393sororally
sovranly1443453sovranly
spacially1645653spacially
spall74919303sp__all_
spalls84217343sp__alls
sparable121611983sparable
sparely123410673spar_ely
sparkily1735023sparkily
sparkly16348133spar_kly
sparsely1335123sparsely
spatially1446793spatially
specially1647343specially
spectrally1744853spectrally
spicily1438653spi_cily
spiffily19153483spiffily
spikily1635873spi_kily
spill74821163spi__ll_
spills84717463spi__lls
spinachy1842793spinachy
spinal84915313spina_l_
spinals93911863spina_ls
spindly13257383spi_ndly
spinelle1046223spinelle
spiracles1345663spiracles
spiraea9407983spira_ea
spiraeas10286233spiraeas
spiraling1237953spiraling
spiralling1343963spiralling
spirant9814293spira_nt
spirants1088283spirants
spirillum1352643spirillum
spiritually16113603spiritually
spirula9257703spir_ula
spirulae10216573spirulae
spirulas10207203spirulas
spiry105017353spir___y
spital83813873spita_l_
spitals93011593spita_ls
spitball1244493spitball_
spitballs1344073spitballs
sporal82915453spora_l_
sportily1337733sportily
spousally1442893spousally
sprawl11188063sp_rawl_
sprawls12176373sp_rawls
spray106720063sp_ra__y
spryly1435513sp_r_yly
spurgall1143263spurgall_
spurgalls1243093spurgalls
squally1937673s_qually
stilly93714093sti__lly
stoically1449673stoically
suitably1347593suitably
superably1648883superably
superalloy1544443superalloy
supernally1546773supernally
surreally1244813surreally
suturally1245953suturally
swirly12439253swir__ly
tidally1137933_tidally
topically1649533topically
tribally1347323tribally
typically1946083typically
vitally1339673_vitally

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621246.48622535.0
3Display Results1241240.0462695.7
 (SQL Overall)1786911246.95225703.5
 
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.