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

138 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
leucite93775(None) 
leucine938071leucine
leucites1037331leucites
lucite8313341l_ucite
eucrite939902_eucrite
excite15310882_excite
lenite6719982le_nite
leucin839112leuci_n
leucines1037272leucines
leucins938102leucins
leucitic1245232leucitic
lucites9311862l_ucites
recite83625112re_cite
reunite7312712reunite
alunite7311633alunite
augite7312613_augite
azurite1638003azurite
bauxite1635573bauxite
brucine1138273brucine
calcite11413783calcite
cecity1398153ce_city
cerite84724873ce_rite
cerusite1047763cerusite
cite65640343___cite
cleveite1343823cleveite
cruciate1287313cruciate
curite85222943_curite
dacite91115883_dacite
decide104116873de_cide
decile94619213de_cile
deicide1149403deicide
despite10410123despite
deuce84517493deuc__e
deucing1139393deucing
dunite7315013_dunite
educate10310213educate
elicit8417203elicit_
elicited1139093elicited
elicits9311233elicits
elite56230183_e_lite
eluate62315433elu_ate
elucidate1265413elucidate
elusive1057003elusive
elute54822573elu__te
eluviate1146953eluviate
endite73817593_endite
erudite838483erudite
eucaine939243_eucaine
euchre11137663_euchre
eucrites1049483_eucrites
evite85317683_e_vite
excide1638423_excide
excise1538553_excise
excited1737853_excited
exciter1637753_exciter
excites16310633_excites
felsite1039083felsite
ferrite103312753ferrite
fleabite1354163fleabite
gunite7414403_gunite
hessite1038993hessite
incite83618733_incite
kernite1159473kernite
laicise939333laicise
laicize1838093laicize
lauwine1036373lauwine
lazulite1745033lazulite
lazurite1745243lazurite
leachate1347443leachate
lechwe1435113le_chwe
lectin82515013le_ctin
legate72917453le_gate
legit61323503le_git_
legits71313003le_gits
leglike12136843leglike
lemurine1046523lemurine
lenited8812433le_nited
lenites7818443le_nites
lenity9612713le_nity
leonine7311233leonine
leucocyte1652933leucocyte
leucoma1144453leucoma
leukocyte1852743leukocyte
levity1277903le_vity
lewisite1154543lewisite
lezzie1435333lezzi_e
licit74327683l_icit_
lignite81310303lignite
lite47054543l___ite
locate83919843l_ocate
louche115212663louc_he
louie55023513lou_i_e
luce65132573l_uc__e
lucid84314573l_uci_d
lucifer1234603l_ucifer
luckie123611413l_uckie
lucre76415523l_uc_re
lunate6316043l_unate
lupine84013533l_upine
lute46341013l_u__te
luxate1338083l_uxate
lyddite1243333lyddite
miscite11314383miscite
neurine7311683neurine
paucity1435823paucity
pelite84323003pe_lite
penlite9313243penlite
perlite9317323perlite
petite84320653pe_tite
preunite1039573preunite
quite144621463_qu_ite
raucity1235853raucity
recipe103414893re_cipe
recit75235103re_cit_
recited104319103re_cited
reciter94117263re_citer
recites93524583re_cites
recits83621353re_cits
reincite1089703reincite
requite162012483requite
resite64128453re_site
respite9513033respite
reunited939713reunited
reuniter838323reuniter
reunites8312473reunites
rewrite10311143rewrite
seducive1444213seducive
suite54829563_su_ite
tectite9310583tectite
tektite1136883tektite
tergite8311003tergite
termite9313893termite
ulexite1445723ule_xite
unite54828383__unite
verite94323443ve_rite
website1235323website
zeolite1638903zeolite
zincite1837233zincite

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.420425454.8
2DLD Change Limit1340271386.20621596.4
3Display Results1381380.0463000.0
 (SQL Overall)1786911386.67226782.2
 
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.