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 “spathic” 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
spathic143754(None) 
empathic1764662empathic
gnathic1344842gnathic
sapphic1644552sapphic
spahi10311142spa_hi_
spahis11310382spa_his
spastic11310382spastic
spathal1236262spathal
spathe115115692spath_e
spathed134013182spathed
spathes125116532spathes
static83118682stat_ic
apatetic1258583apatetic
apathetic1647853apathetic
apathies1339003apathies
apathy1437033apath_y
astatic9514193astat_ic
attic75618353__attic
benthic1437473benthic
edaphic1544243edaphic
enatic8317563enat_ic
erethic1257723erethic
ethic101511223__ethic
gothic1237793_gothic
graphic1537353graphic
haptic13511893hapt_ic
hepatic141712773hepat_ic
iatric8312163_iatric
isobathic1652843isobathic
lathi85417203_lathi_
lathis95516173_lathis
lithic1139493_lithic
myopathic2154413myopathic
mythic1637273_mythic
optic93715183op_t_ic
osmatic11179983osmat_ic
panic93923903_pa_nic
path99134913_path__
pathetic15410963_pathetic
pathos115516693_pathos
paths105521383_path_s
patin76832853_pat_in
patio74426353_pat_io
patois84319363_patois
pattie84020963_pattie
phatic133014413phat_ic
psalmic1345333psalmic
psoatic1139303psoat_ic
psychic1944833psychic
sahib10314763s_a_hib
salic73424713s_a_lic
sapphics1743413sapphics
satanic939933s_atanic
sati45539333s_at_i_
satin55935223s_at_in
satiric939243s_atiric
satis55633683s_at_is
satyric1237493s_atyric
scaldic1235943scaldic
scandic1237003scandic
scathe114414993scath_e
scathed134012643scathed
scathes124515713scathes
scathing14269703scathing
sciatic11910173sciat_ic
sematic111716873semat_ic
septic102713193sept_ic
seraphic1546633seraphic
sialic8313633sia_lic
skaldic1443553skaldic
slather103816073slather
snath86419803snath__
snathe94415113snath_e
snathes104816493snathes
snaths95112913snath_s
somatic111916463somat_ic
spadix1636113spa_dix
spagyric1642053spagyric
spahee11313443spa_hee
spail74921553spa__il
spait75631603spa__it
sparid94016933spa_rid
sparoid102311543sparoid
spastics1237503spastics
spat66548523spat___
spate74731583spat__e
spates85028173spat_es
spathose1345633spathose
spatial9310323spatial
spats75031383spat__s
spatted104014143spatted
spatter94016523spatter
spatting113111763spatting
spatula935893spatula
spatzle1834583spatzle
spavie113611383spa_vie
spavin114210653spa_vin
spermic1338523spermic
sphenic1449093sphenic
spheric14510073spheric
spic85227433sp___ic
splenic1148663splenic
spotlit947303spotlit
sputnik1372273sputnik
stannic936663stannic
statice92614033stat_ice
statics93314533stat_ics
statin63921473stat_in
stichic1446243stichic
stoic7317253s__toic
swath115920383swath__
swathe125514113swath_e
swathed144611933swathed
swather134213603swather
swathes134115513swathes
swathing15248713swathing
swaths125312643swath_s
sylphic1745883sylphic
sympathin1953863sympathin
sympatric1864443sympatric
uratic83016353urat_ic
vatic10316423_vat_ic
viatic11311453viat_ic
xanthic1945863xanthic

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271246.96619240.2
3Display Results1241240.0462695.7
 (SQL Overall)1786911247.41824088.8
 
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.