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

57 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
ergastic1110662(None) 
orgastic11116211orgastic
drastic10310872dr_astic
elastic93013392e_lastic
entastic1048552entastic
ergotic1049722erg_otic
eristic9814092er_istic
erratic9311112erra_tic
orgasmic1363632orgasmic
orgiastic1243692orgiastic
agrestic1147923agrestic
aplastic1249243aplastic
argentic1149023argentic
argotic10310283arg_otic
artistic10310893artistic
chiastic15287483chiastic
clastic113013963_clastic
dicastic1347343dicastic
digastric1343613digastric
dynastic1445853dynastic
ectatic11310123ecta_tic
egoistic1147103egoistic
ekistic1377843e_kistic
elastics102710883e_lastics
elastin72611843e_lastin
enatic8317563e_na_tic
encaustic1343393encaustic
epigastric1551883epigastric
epinastic1344953epinastic
eremitic1248543eremitic
ergate7315143erga_t_e
ergates8314493erga_tes
ergative1238973erga_tive
ergodic1145503erg_odic
eristics10610193er_istics
erotic82620273er__otic
erratics1046983erra_tics
euplastic1345463euplastic
frantic12310363fr_antic
gastric1038633__gastric
gestic9312773__gestic
gigantic1244303gigantic
logistic1147823logistic
mastic103119173__mastic
meristic12311253mer_istic
monastic1249863monastic
nastic82915973__nastic
organic1038313orga_nic
plastic112815063_plastic
practic13312243pr_actic
rustic8712673_r_ustic
sarcastic1365693sarcastic
spastic11310383_spastic
triassic1044633triassic
truistic1046903truistic
uratic83016353ur_a_tic
veristic1339883ver_istic

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162576.56322270.6
3Display Results57570.0163562.5
 (SQL Overall)178691576.73526531.7
 
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.