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

66 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
cymatia144644(None) 
comatic131816942comatic
comatik15139722comatik
comitia1139722comitia
cymatium1743702cymatium
himatia1248592himatia
acmatic13311703acmatic
bemata10411693bemat_a
camail10314833cama_il
cambia124913153cam_bia
camelia11510443camelia
camisia112810243camisia
cavatina1347333cavatina
ceratin93020163ceratin
clematis1248653clematis
climatic1448733climatic
coati75624643c_oati_
coatis85122603c_oatis
comate104124843comat_e
comates114123643comates
comatiks16148043comatiks
comatula1244263comatula
cometic131215723cometic
comitial1248693comitial
commata1338483commat_a
crania82418433c_rania
creatin93618133creatin
cumarin1139263cumarin
cumbia12379893cum_bia
cyanic133110773cy_anic
cyanid123912043cy_anid
cyanin113911453cy_anin
cycasin1445903cycasin
cyma116715843cym___a
cymae126713013cyma__e
cymar125711263cyma__r
cymars13599153cyma_rs
cymas126417883cyma__s
cymbidia1842083cymbidia
cymlin1337313cym_lin
cymoid1459473cym_oid
cystic132710653cy_stic
gematria1175693gematria
gymnasia1442983gymnasia
hamartia13115953hamartia
hematic141816753hematic
hematin121516023hematin
hydatid1546523hydatid
hymenia1546393hymenia
ignatia846133ignatia
komatik12135203komatik
mafia104418033__mafia
mania75634153__mania
maria75032883__maria
matin75132853__matin
matza16311813__matza
myomata1445923myomat_a
nematic111714003nematic
osmatic11179993osmatic
sematic111716883sematic
solatia7312253solatia
somata8312383somat_a
somatic111916473somatic
trymata1244223trymat_a
yautia937253_yautia
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.423422437.4
2DLD Change Limit134027666.59320328.7
3Display Results66660.0164125.0
 (SQL Overall)178691667.03225411.1
 
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.