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

127 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
spinally133802(None) 
spirally1348021spirally
apically1539832apically
clinally1347232clinally
epically15310582epically
finally13310102_finally
penally121111772_penally
seminally1458802seminally
signally1246532signally
spinachy1842792spinachy
spinal84915312spina_l_
spinals93911862spina_ls
spindly13257382spin_dly
spinelle1046222spinelle
actinally1448233actinally
anally9513503__anally
animally1368643animally
atonally1148633atonally
axially1737233axi_ally
banally1249223_banally
bridally1446453bridally
capitally1646663capitally
carnally1339523carnally
clonally1346693clonally
coitally1339483coitally
epinasty1343133epinasty
faunally1445433faunally
geminally1576403geminally
genially12129523genially
laically1338983laically
lineally1137793_lineally
menially131111093menially
misally121111063_misally
nominally1446803nominally
nounally1146483nounally
optically1649903optically
optimally1644563optimally
optionally1545943optionally
ordinally1346293ordinally
osmically1647323osmically
pally105727123_p__ally
papally1437973_papally
penalty1267743_penalty
pinball1137933_pinball_
pinballs1246933_pinballs
pinkly155012243_pin_kly
saintly1039343sain_tly
sally85129713s___ally
serially11912843serially
sexually1845613sexually
shingly143210813shin_gly
shinily13268933shin_ily
silly84527623s_i__lly
sinfully1445613s_infully
singly104015853s_in_gly
sizably2136613s_izably
slinkily1534853slinkily
snarly93815003s__narly
socially1338543socially
sonically14310953sonically
spacially1645653spacially
spall74919303sp__all_
spalls84217343sp__alls
spangly1336473span_gly
spatially1446793spatially
specially1647343specially
spicily1438653spi_cily
spiffily19153483spiffily
spikily1635873spi_kily
spill74821163spi__ll_
spills84717463spi__lls
spinach1435403spina_ch
spinage10289653spina_ge
spinages11289293spinages
spinate93114813spina_te
spindle103210093spin_dle
spindled12287643spindled
spindler11297983spindler
spindles112710353spindles
spinel85317333spin_el_
spinelles1146083spinelles
spinels94512443spin_els
spinnery13416593spinnery
spinney12438923spin_ney
spinny114510183spin__ny
spinosely1442533spinosely
spinula9257903spin_ula
spinulae10276963spinulae
spinule9299993spin_ule
spinules10249333spinules
spiny104921303spin___y
spiracle1255803spiracle
spiral83715343spira_l_
spiraled1137733spiraled
spirality1446433spirality
spiralled1244403spiralled
spirals93212513spira_ls
spirilla1045073spirilla
spital83813873spita_l_
spitals93011593spita_ls
spitball1244493spitball_
spitballs1344073spitballs
spongily1444903spongily
spousally1442893spousally
sprawly15166043sp_rawly
springily1545583springily
spunkily1733773spunkily
squally1937673s_qually
stilly93714093sti__lly
stingily1236793stingily
stoically1449673stoically
suitably1347593suitably
supernally1546773supernally
supinely1376293supin_ely
tarnally1138273tarnally
tidally1137933_tidally
tonally10311373_tonally
topically1649533topically
tribally1347323tribally
typically1946083typically
vaginally1645233vaginally
venally13119563_venally
venially1499423venially
vernally1447823vernally
virally1339653_virally
vitally1339673_vitally
zonally1938003_zonally

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.420425454.8
2DLD Change Limit1461621277.19020328.5
3Display Results1271270.0432953.5
 (SQL Overall)1786911277.65323349.1
 
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.