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

45 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
peridotic144648(None) 
periotic12313441peri_otic
epidotic1346882_epidotic
pericopic1745542pericopic
peridot10514242peridot__
peridotite1354922peridotite
peridotitic1653032peridotitic
peridots1138322peridot_s
periodic1348432peri_odic
acidotic1355983_acidotic
aperiodic1444063aperi_odic
cerotic11415063cer__otic
eidetic1039743_e_idetic
eidolic1047063_e_idolic
ergotic1049723_er_gotic
eristic9814093_eri_stic
erotic82620273_er__otic
keratotic1545643keratotic
lordotic1144993lor_dotic
meiotic11410933me_i_otic
meristic12311253meri_stic
neritic91314333neri__tic
parotic112518043par__otic
patriotic13107583patri_otic
pelitic111814653peli__tic
peridia10312363perid__ia
peridotites1454253peridotites
periodid1248163peri_odid
periodontics1762433periodontics
peripetia1346653peripetia
periphytic2264873periphytic
periscopic1854423periscopic
periti8319953peri__ti_
perlitic12310583per_litic
phimotic1747153p_himotic
prebiotic1545413prebiotic
psilotic1245773p_silotic
puristic1239383puri_stic
pyridic15267833pyrid__ic
pyridoxin2252603pyridoxin
pyritic143311313pyri__tic
semiotic12710633semi_otic
veridic1338143verid__ic
veristic1339883veri_stic
xerotic16410863xer__otic

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 Filter1786911486410.423422437.4
2DLD Change Limit148641456.56322648.3
3Display Results45450.0133461.5
 (SQL Overall)178691456.99925530.9
 
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.