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

193 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
lignites912961(None) 
ignites81310581_ignites
lignite81310301lignite_
dignities1149592dignities
finites10315922fi_nites
gelignites1243582gelignites
ignite71410582_ignite_
ignited9137622_ignited
igniter8147672_igniter
igniters9126232_igniters
lenites7818442l_enites
ligates82318382lig_ates
lignifies1346262lignifies
lignins84010492ligni_ns
lignitic1146392lignitic
limites92915452li_mites
limonites1148002limonites
lionises8310312lionises
lionizes1738772lionizes
pinites9319532pi_nites
reignites1046932reignites
sienites8311912sienites
aconites10314353aconites
agnates82813193_agnates
agnizes17328843_agnizes
alginates10310123alginates
alienates9310683alienates
allanites949803allanites
alunites8310703alunites
arenites8917103arenites
augites8312183aug_ites
biggies113813523biggi_es
binits85716673bi_nit_s
biotites10310083biotites
blighties1546223blighties
bornites10310983bornites
cognates11311583cognates
cognises11610043cognises
cognizes2058033cognizes
crinites10612763crinites
cyanites132610163cyanites
digits84114533dig_it_s
dignifies1446363dignifies
dignity1236453dignit_y
dingies93618243dingi_es
diorites9313523diorites
disunites1088673disunites
dunites8313593_dunites
dunnites947173dunnites
ebonites1039233ebonites
eighties12710803eighties
finises10312903fi_nises
finite9316823fi_nite_
flinkites1643483flinkites
gahnites1235703gahnites
gelignite1143993gelignite_
gites65630183__g_ites
granites92116363granites
gunites8313123_gunites
hinnies103615103hinni_es
ichnites1345743ichnites
ignifies1277563_ignifies
ignitor8125263_ignitor
ignitors9135513_ignitors
ignores8269003_ignores
illites72415013_illites
ilmenites1146103ilmenites
incites93218483_incites
indites83618983_indites
ingates82716913_ingates
invites103915813_invites
iolites73819483_iolites
ionises72916433_ionises
ionizes162813343_ionizes
kainites1238793kainites
kernites1269113kernites
kyanites15216683kyanites
legates82917683leg_ates
legits71313003leg_it_s
lenite6719983l_enite_
lenited8812433l_enited
lenities8315943l_enities
leucites1037333leucites
liaises7311053li_aises
lianes63819323lian__es
librates103412953librates
ligases82310713lig_ases
ligate72519253lig_ate_
ligated92414143lig_ated
lighted122913503lig_hted
lighten112811523lig_hten
lightens122510003lig_htens
lighter113113443lig_hter
lighters123111393lig_hters
lightest121410353lig_htest
lights104519913lig_ht_s
lignaloes1054033lignaloes
lignans8398853lign_ans
ligneous945233ligneous
lignified1445063lignified
lignify1443793ligni_fy
lignin74911193ligni__n
ligroines1044993ligroines
ligules82210923lig_ules
ligures8269893lig_ures
lilies63021413li_li_es
limited102310233li_mited
limiteds11184543li_miteds
limiter92710853li_miter
limiters10249333li_miters
limits82514143li_mit_s
limonite1048163limonite_
linages8813173li_nages
lindies8416583li_ndies
lines57054573li_n__es
lingier84113383lingi_er
lingiest93715263lingi_est
lingoes84014693li_ngoes
linguines1046513linguines
linier64423793li_ni_er
liniest73321153li_ni_est
linings84313073li_nings
linins65922143li_ni_ns
linnets739833linnet_s
linted74021823li_n_ted
lintel64013993li_n_tel
lintels73311163li_n_tels
linter64625343li_n_ter
linters73822633li_n_ters
lintier73613803li_ntier
lintiest82715913li_ntiest
lints57137193li_n_t_s
lionise7310373lionise_
lionised946603lionised
lioniser845583lioniser
lionisers944173lionisers
lionize1668823lionize_
lionized1837023lionized
lionizer1756053lionizer
lionizers1844243lionizers
lipides103810623li_pides
liquates1737453liquates
litanies8310993litani_es
litotes7311183li_totes
longies82916553longi_es
loonies73919543looni_es
lucites9311863l_ucites
luggies93011213luggi_es
lunies64723013l_uni_es
lyddites1342583lyddites
magnates11511613magnates
malignities1464873malignities
mannites10312613mannites
melinites11310413meli_nites
migrates111112853migrates
minnies93617363minni_es
minutes93513443mi_nutes
miscites12313783miscites
nighties121011383nighties
ninnies73713613ninni_es
niobites1037313niobites
nites55736343___nites
nitrites82313453nitrites
olivenites1343333olivenites
picrites121811083picrites
pigeonites1343903pigeonites
piggies113813483piggi_es
pigmies122610993pigmi_es
pignuts1035613pignut_s
pigsties1139783pigsties
pinite8321243pi_nite_
pinnies93318443pinni_es
reignite947233reignite_
reignited1145683reignited
reunites8312473reunites
righties12711573righties
sienite7312713sienite_
signages1037483signages
signees83510803sign_ees
signeted1035973signeted
signets83311503signet_s
signifies1347063signifies
signiors944923signiors
stibnites1144043stibnites
syenites1138943syenites
tillites8312833tillites
tinnitus843783tinnitus
titanites997413titanites
unites65024853__unites
uranites82514643uranites
vignettes1344673vignettes
wienies102213683wieni_es
zincites1946633zincites

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.436409841.7
2DLD Change Limit1461621936.62622058.9
3Display Results1931930.0762539.5
 (SQL Overall)1786911937.13825033.8
 
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.