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

157 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
eucrite93990(None) 
eucrites1049481eucrites
cuprite1159682cuprite
curite85222942cu_rite
eccrine1137282eccrine
eucaine939242eucaine
eucritic1247132eucritic
excite15310882exc_ite
excrete1667162excrete
leucite937752leuc_ite
lucite8313342luc_ite
picrite111911312picrite
accrete1137843accrete
ascribe1147743ascribe
attrite7311833attrite
augite7312613au_gite
aurate64426473au_rate
azurite1638003azurite
barite84224813_barite
becrime1387053becrime
burkite1337003burkite
burrito936223burrito
cerite84724873_cerite
cite65640343__c_ite
cowrite123612683cowrite
crate76537403__crate
crime94822693__crime
cripe95521143__cripe
crit65743713__crit_
crits75527573__crits
cuprites1259023cuprites
curate85226243cu_rate
curiae84518373cu_riae
curie74533043cu_ri_e
curites93919863cu_rites
currie84317263curri_e
dacite91115883dac_ite
dendrite1048783dendrite
describe1346243describe
diorite8314913diorite
duckie133511663ducki_e
ductile1048483ductile
dunite7315013du_nite
dunnite857333dunnite
durrie73713263durri_e
ebonite9310293ebonite
ecarte84313503e_carte
educate10310213educ_ate
eductive1476863eductive
eerie55228533e_eri_e
egalite8311563egalite
elite56230183e__lite
elutriate945303elutriate
embrute1145703embrute
emerita938713emerita
emeritae1046353emeritae
emeriti949433emeriti
emirate91015833emirate
emprise11310723emprise
emprize2038843emprize
enceinte1046263enceinte
encrinite1146043encrinite
endite73817593e_ndite
eremite9312833eremite
eructate1047333eructate
erudite838483erudite
eserine7415903eserine
esprit8312843esprit_
esprits938393esprits
eucaines1038513eucaines
eucaryote1452463eucaryote
euchre11137663euc_hre
euchring1436613euchring
euclase938933euclase
euripi856083eu_ripi
euxenite1545443euxenite
evite85317683e__vite
excide1638423exc_ide
excise1538553exc_ise
excited1737853exc_ited
exciter1637753exc_iter
excites16310633exc_ites
excoriate1846883excoriate
excreta1674623excreta
excreted1846153excreted
excreter1766123excreter
excretes1787573excretes
execrate1739653execrate
exocrine1745993exocrine
eyrie88117833e_yri_e
ferrite103312753ferrite
fluorite1147893fluorite
furcate12310453furcate
gummite1236133gummite
gunite7414403gu_nite
incite83618733inc_ite
kunzite2053503kunzite
leucine938073leuc_ine
leucites1037333leuc_ites
lucites9311863luc_ites
luckie123611413lucki_e
lucre76415523lucr__e
mullite9313013mullite
muriate9313363mu_riate
murine84220023mu_rine
murrine9411483murrine
nephrite1346713nephrite
neurine7311683neu_rine
nitrite72314463nitrite
norite63221133_norite
nuclide1037173nuclide
ourie54027303ou_ri_e
outrate72323183outrate
outride82615683outride
outwrite1139453outwrite
picrate112014143picrate
picrites121811083picrites
puerile9310093puerile
purine85321893pu_rine
purity114114913pu_rity
pyrite11913313_pyrite
quarte154115323quar_te
quite144621463qu__ite
recite83625113rec_ite
recrate92621663recrate
reunite7312713reu_nite
rewrite10311143rewrite
rite45849453___rite
scribe104613533_scribe
scrive115414943_scrive
secrete9311073secrete
security1346693security
sprite84421773_sprite
subsite9412873subsite
sucrase9310343sucrase
sucre75019103sucr__e
sucrose939303sucrose
suite54829563su__ite
sulfite10310473sulfite
sunrise7310813sunrise
tacrine9311293tacrine
tectite9310583tectite
tenorite8311993tenorite
tephrite1346593tephrite
thorite10313443thorite
trite54730033__trite
turgite837973turgite
uncrate9415953uncrate
unite54828383_u_nite
unripe82012093_unripe
uprate83916543_uprate
uprise82313693_uprise
urate55432163_u_rate
urine55026593_u_rine
verite94323443_verite
write85522833__write
yperite1249893yperite

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.1561145455.1
2DLD Change Limit1340271577.04619021.7
3Display Results1571570.0602616.7
 (SQL Overall)1786911577.26224606.3
 
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.