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 “osmatid” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

69 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
osmatic11179981osmatic
osmotic11127612osmotic
somatic111916462somatic
acmatic13311693acmatic
anosmatic1347733anosmatic
ascarid103910723ascarid
astatic9514193astatic
basmati1148233basmati_
basmatis1247343basmatis
comatic131816933comatic
comatik15139723comatik
cosmetic1447783cosmetic
cosmid11810643cosm__id
cymatia1446443cymatia
dogmatic1447623dogmatic
estated83715573estated
hematic141816743hematic
hematin121516023hematin
hematoid1449753hematoid
himatia1248593himatia
hydatid1546523hydatid
isatin6412213is_atin
komatik12135203komatik
maid75537663__ma_id
mantid93820383__mantid
mated85537783__mated
matin75132853__matin
mismated131111333mismated
nematic111713993nematic
ommatidia1451653ommatidia
ootid61416703o__otid
opiated1039483opiated
orated74221503o_rated
oribatid1145463oribatid
osmic939913osm__ic
osmosed10134843osmosed
osmosis976573osmosis
osmund933803osm_und
osteoid848193osteoid
ostia52315583os__tia
oxyacid2062773oxyacid
ozalid1696683o_zalid
psoatic1139303psoatic
remated103522473remated
said55742113_s_a_id
sapid84720933_s_apid
sated66238533_s_ated
sati45539333_s_ati_
satin55935223_s_atin
satis55633683_s_atis
sayid95516723_s_ayid
seated75131063_seated
sematic111716873sematic
sialid7314943_sialid
skated114414883_skated
slated75028313_slated
smalti84111193_smalti_
smarted105012613_smarted
smartie9310173_smartie
solated83618023solated
solatia7312253solatia
somata8312383somat_a
somitic111512633somitic
sparid94016933_sparid
staid66722083_sta_id
stated75427833_stated
static83118683_static
statin63921473_statin
unmated103317023unmated

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 Filter1786911340270.390458182.1
2DLD Change Limit134027696.03322215.6
3Display Results69690.0302300.0
 (SQL Overall)178691696.45327691.2
 
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.