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

128 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
osmatic1117998(None) 
osmotic11127611osmotic
somatic111916461somatic
acmatic13311692acmatic
anosmatic1347732anosmatic
astatic9514192astatic
comatic131816932comatic
cosmetic1447782cosmetic
dogmatic1447622dogmatic
hematic141816742hematic
nematic111713992nematic
osmic939912osm__ic
psoatic1139302psoatic
sematic111716872sematic
somitic111512632somitic
static83118682_static
agnatic10310973agnatic
aposematic1654253aposematic
aquatic1838113aquatic
aromatic12315633aromatic
ascetic11310063ascetic
ascitic1139323ascitic
aseptic1137373aseptic
asthmatic1647583asthmatic
aviatic1239243aviatic
basmati1148233basmati_
basmatis1247343basmatis
climatic1448723climatic
comatik15139723comatik
cometic131215723cometic
cosmetics1545463cosmetics
cosmic12410343cosm__ic
coumaric1446173coumaric
cymatia1446443cymatia
dalmatic1348683dalmatic
demotic12412343demotic
dogmatics1544873dogmatics
dramatic1369423dramatic
ecstatic1246153ecstatic
ectatic11310123ectatic
emetic10614453_emetic
enatic8317563_enatic
erratic9311113erratic
eustatic1047343eustatic
exosmotic2043423exosmotic
fanatic12610693fanatic
fumaric1446303fumaric
gametic1239993gametic
haematic151310213haematic
hematics151712193hematics
hematin121516023hematin
hepatic141712773hepatic
himatia1248593himatia
isatin6412213is_atin
isosmotic1343653isosmotic
isostatic1145353isostatic
kismetic1644883kismetic
komatik12135203komatik
lunatic938753lunatic
mafic125615463__mafic
magic105818653__magic
magmatic1548393magmatic
malic94525663__malic
manic94629443__manic
mantic104120903__mantic
mastic103119173__mastic
matin75132853__matin
miasmatic1545623miasmatic
mimetic1338653mimetic
mosaic10311143mos_a_ic
neumatic1258523neumatic
nomadic1248033nomadic
nonstatic1148463nonstatic
oceanic1146163oceanic
octadic1245713octadic
oghamic1544043oghamic
ohmic1237833ohm__ic
onomastic1346813onomastic
ontic74418573o__ntic
oolitic92512883oolitic
operatic1249933operatic
ophitic1439213ophitic
optic93715183o__ptic
orectic1138823orectic
organic1038313organic
orgastic11116213orgastic
osmics1036463osm__ics
osmosis976573osmosis
ossific1243103ossific
osteitic1046943osteitic
ostia52315583os__tia
otic66624823o___tic
otitic83112683o_titic
oxalic1537093o_xalic
phatic133014413_phatic
piratic11314293piratic
plasmatic1547213plasmatic
prismatic1547163prismatic
prostatic13410853prostatic
rhematic15188923rhematic
romantic1249233romantic
salic73424713_s_alic
sati45539333_s_ati_
satin55935223_s_atin
satis55633683_s_atis
sciatic11910173sciatic
semantic1249553semantic
septic102713193_septic
sialic8313633_sialic
smalti84111193_smalti_
smartie9310173_smartie
smectic1336613_smectic
solatia7312253solatia
somata8312383somat_a
sonantic1048273sonantic
soritic91414433soritic
spastic11310383_spastic
spathic1437543_spathic
statice92614033_statice
statics93314533_statics
statin63921473_statin
stomatic12311993stomatic
thematic152011483thematic
uratic83016353_uratic
vatic10316423__vatic
venatic12311523venatic
viatic11311453_viatic
zymotic2345713zymotic

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.1401276364.3
2DLD Change Limit1340271287.12618808.2
3Display Results1281280.0462782.6
 (SQL Overall)1786911287.31224438.0
 
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.