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 “digital” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
digital93706(None) 
digitals1045431digitals
digit73825272digit__
digitalin1154102digitalin
digitalis1144962digitalis
digitally1445662digitally
digitate1098682digitate
digits84114532digit_s
distal73615772di_stal
adagial946373adagi_al
agita6315423_agita_
agitas7310593_agitas
anginal8310163anginal
bimetal1138433bimetal
capital112311523capital
chital114313883_chital
coital84117053_coital
cubital1137103cubital
datival1135583datival
decimal1238083decimal
deicidal1245713deicidal
deifical1445543deifical
denial74720513deni_al
dental74319173d_ental
detrital946573detrital
devisal1136913devisal
diagonal1095653diagonal
dial55935073d__i_al
diastral946993diastral
dicotyl1344403dicotyl
dicrotal1146823dicrotal
dicta84915633di_cta_
dight104027003dight__
dighted132511493dighted
dights114016963dight_s
digitalins1254023digitalins
digitalize2145863digitalize
digitated1286963digitated
digitately1552873digitately
digitize1947023digitize
dignitary1442463dignitary
dignity1236463dignit_y
diktat11310693di_ktat
dimity12310483dimit_y
dinitro845563dinitro
dioptral1144683dioptral
dismal92412243di_smal
distil73616433di_stil
distill83011323distill
dita56032533d__ita_
ditas65923673d__itas
diurnal844883diurnal
dividual1344053dividual
dixit134420593dixit__
dixits144210313dixit_s
domical1239373domical
dotal64919623d__otal
ductal938993d_uctal
edictal1046993edi_ctal
figural1145243figural
filial93013253fili_al
finial92814183fini_al
finical1239703finical
genital849793genital
gingival1342943gingival
hiatal9310203hi_atal
hightail1545273hightail
ilial55317843_ili_al
initial7311883_initial
instal6712193_instal
invital1046953invital
lanital7310913lanital
liminal93810673liminal
logical1038513logical
magical1239783magical
marital92314183marital
mimical1339233mimical
minimal114010603minimal
ogival1035873_ogival
orbital936923orbital
original956793original
paginal10269493paginal
pigtail1046623pig_tail
pinitol936683pinitol
pivotal1245433pivotal
recital9412173recital
reginal84814293reginal
rictal83113193ri_ctal
sagittal943283sagittal
segetal868383segetal
sigil63515503sigi__l
signal73711483sig_nal
simitar936733simitar
somital939403somital
spital83813873_spital
tibial849843tibi_al
vaginal11288403vaginal
vegetal1156303vegetal
vicinal12268543vicinal
vigia94813273vigi_a_
vigias104110893vigi_as
vigil94313003vigi__l
viminal12288823viminal
virginal1244573virginal
vital84819673__vital

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271056.31321230.3
3Display Results1051050.0303500.0
 (SQL Overall)1786911056.74926476.7
 
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.