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

67 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
sonantic104827(None) 
monastic1249862monastic
romantic1249232romantic
semantic1249552semantic
somatic111916462soma_tic
sonant6621952sonant__
sonantal886262sonantal
sonants7511232sonant_s
synaptic1546282synaptic
agnatic10310973agna_tic
antic75728863___antic
botanic1159583botan_ic
cantic103920543__cantic
cobaltic1455913cobaltic
comatic131816933coma_tic
dynastic1445853dynastic
enatic8317563_ena_tic
fanatic12610693fana_tic
frantic12310363_frantic
geomantic1445983geomantic
gigantic1244303gigantic
gonadic1177213gona_dic
isotactic1344243isotactic
lunatic938753luna_tic
mantic104120903__mantic
monadic1268883mona_dic
monastics1346803monastics
monistic12311303monistic
nastic82915973__nastic
onanistic1147373_onanistic
ontic74418573_o__ntic
osmatic11179983osma_tic
pedantic1346583pedantic
psoatic1139303pso_a_tic
quantic18279063_quantic
romantics1346783romantics
santir6315253s__antir
satanic939933satan_ic
scandic1237003s_candic
sciatic11910173scia_tic
semantics1346823semantics
sematic111716873sema_tic
shanti94014093s_hanti_
shantih13309643s_hantih
shantis103313103s_hantis
solanin7311943solan_in
solatia7312253sola_tia
somitic111512633so_mitic
sonance9310313sonan_ce
sonances10310263sonances
sonata6313223sona_t_a
sonatas7510293sona_tas
sonatina849073sona_tina
sonatine8313323sona_tine
sonic75225293so__n_ic
soritic91414433so_ritic
spastic11310383s_pastic
stannic936663s_tannic
static83118683s_ta_tic
stomatic12311993stoma_tic
strontic1048103strontic
syndetic1446033syndetic
synectic1546333synectic
synoptic1546923synoptic
syntactic1644553syntactic
tonetic9313433ton_etic
venatic12311523vena_tic

Search took 9 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.436409841.7
2DLD Change Limit146162677.56319325.9
3Display Results67670.0164187.5
 (SQL Overall)178691678.01522294.6
 
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.