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

78 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
chiastic1528748(None) 
chiasmic17295021chiasmic
chaotic14310042ch_aotic
chasmic16177982ch_asmic
chianti1236612chianti_
chiantis1346592chiantis
chiasmatic1954342chiasmatic
chiasmi14365582chiasmi_
chiliastic1753712chiliastic
clastic113013962c_lastic
aplastic1249243aplastic
archaistic1745073archaistic
aviatic1239243avia_tic
bhistie1236773bhi_stie
cantic103920543c__antic
caseic103212373c__aseic
caustic1139753c_austic
chassis123910663ch_assis
chaste114617393ch_ast_e
chasten124312403ch_asten
chaster124718503ch_aster
chastise1348173ch_astise
chastity1645273ch_astity
chias104625523chias___
chiasm13449103chias__m
chiasma14366993chias_ma
chiasmal15285033chiasmal
chiasmas15306593chiasmas
chiasms14357523chias_ms
chiasmus15343913chiasmus
chimaeric1844333chimaeric
chimeric1746743chimeric
chitin113114963chi__tin
chivalric1952703chivalric
chopstick2243063chopstick
christie1347783christie
classic113710113c_lassic
clastics122811413c_lastics
climactic1443423climactic
climatic1448733climatic
clitic103315053cli__tic
cobaltic1455913cobaltic
comatic131816943coma_tic
copasetic1554423copasetic
crisic103611843cri_s_ic
critic103616813cri__tic
cubistic1445703cubistic
cystic132710653c__ystic
deistic10311173dei_stic
dicastic1347343dicastic
drastic10310883_drastic
dynastic1445853dynastic
ekistic1377843eki_stic
elastic93013393_elastic
entastic1048553entastic
epinastic1344953epinastic
ergastic11106623ergastic
eristic9814093eri_stic
fistic11812573_fi_stic
haptic13511893_h_aptic
ischiatic1644293ischia_tic
mastic103119173__mastic
miasmic1335743_miasmic
monastic1249863monastic
nastic82915973__nastic
orgastic11116213orgastic
orgiastic1243693orgiastic
phasic133612053ph_as_ic
phatic133014413ph_a_tic
phimotic1747153phimotic
plastic112815063_plastic
scholastic1745863scholastic
scholiastic1854113scholiastic
sciatic11910173scia_tic
spastic11310383_spastic
theistic1348153theistic
triassic1044633triassic
viatic11311453_via_tic

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 Filter1786911461620.420425454.8
2DLD Change Limit146162786.83021400.0
3Display Results78780.0302600.0
 (SQL Overall)178691787.28024545.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.