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

145 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
leucites103733(None) 
leucines1037271leucines
leucite937751leucite_
lucites9311861l_ucites
eucrites1049482_eucrites
excites16310632_excites
lenites7818442le_nites
leucine938072leucine_
leucins938102leuci_ns
leucitic1245232leucitic
lucite8313342l_ucite_
recites93524582re_cites
reunites8312472reunites
alunites8310703alunites
ascites9312603_ascites
augites8312183_augites
azurites1737283azurites
bauxites1735153bauxites
brucines1237763brucines
calcites12313003calcites
cecities12312043ce_cities
cercises12410933cercises
cerites94823433ce_rites
cerusites1146523cerusites
cites74435593___cites
cleveites1443703cleveites
crudites1137763crudites
curites93919863_curites
dacites101114593_dacites
decides114217653de_cides
deciles104417723de_ciles
deicides1249303deicides
despites11410313despites
deuces94015513deuc__es
dunites8313593_dunites
educates1139623educates
elicited1139093elicited
elicits9311233elicit_s
elites66027123_e_lites
eluates72014683elu_ates
elucidates1364883elucidates
elutes64020313elu__tes
eluviates1246103eluviates
endites83717063_endites
equites162212493_equites
eucaines1038513_eucaines
euchres1288663_euchres
eucrite939903_eucrite_
evites94916473_e_vites
excides1738343_excides
excises1638933_excises
excite15310883_excite_
excited1737853_excited
exciter1637753_exciter
exciters1736323_exciters
felsites1138073felsites
ferrites112312833ferrites
fleabites1443613fleabites
gunites8313123_gunites
hessites1138613hessites
incites93218483_incites
kernites1269113kernites
laicises1039573laicises
laicizes1937403laicizes
lauwines1145713lauwines
lazulites1844253lazulites
lazurites1844583lazurites
leachates1446663leachates
leaches123319343leac_hes
lealties8310793lealties
leches115421313le_c_hes
lechwes1535063le_chwes
lectins92515003le_ctins
leeches123911933leec_hes
lefties10312073lefti_es
legacies1139043legaci_es
legates82917683le_gates
legits71313003le_git_s
lenite6719983le_nite_
lenited8812433le_nited
lenities8315943le_nities
letches124015483letc_hes
leucin839113leuci__n
leucocytes1752993leucocytes
leucomas1244453leucomas
leudes75314093leu__des
leukocytes1952823leukocytes
leukoses1244613leukoses
levies93919863le_vi_es
levities11310713le_vities
lewises1039133le_wises
lewisites1244213lewisites
lezzies1536203lezzi_es
lignites9129613lignites
limites92915453l_imites
locates93218813l_ocates
louies64525103lou_i_es
luces75528433l_uc__es
lucifer1234603l_ucifer
lucifers1334163l_ucifers
luckies133313683l_uckies
lucres84513303l_uc_res
lunies64723013l_uni_es
lupines93912503l_upines
lutes55836663l_u__tes
luxates1436973l_uxates
lyddites1342583lyddites
mercies113817563merci_es
miscites12313783miscites
neurines8311193neurines
neuritis848493neuritis
paucities1348503paucities
pelites93821993pe_lites
penlites10312273penlites
perlites10316363perlites
petites93820203pe_tites
preunites1138933preunites
raucities1148163raucities
recipes113314463re_cipes
recite83625113re_cite_
recited104319103re_cited
reciter94117263re_citer
reciters102613113re_citers
recits83621353re_cit_s
reincites1148493reincites
requites171511763requites
resites74027793re_sites
respites10513243respites
reunite7312713reunite_
reunited939713reunited
reuniter838323reuniter
reuniters936423reuniters
rewrites11311063rewrites
suites63727403_su_ites
tectites1039993tectites
tektites1236613tektites
tergites9310543tergites
termites10313693termites
ulexites1534943ule_xites
unites65024853__unites
velites103417303ve_lites
verites103822263ve_rites
websites1335183websites
zeolites1738383zeolites
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.530337152.8
2DLD Change Limit1461621456.97020970.2
3Display Results1451450.0463152.2
 (SQL Overall)1786911457.54623680.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.