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 “laterites” 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
laterites971505(None) 
elaterites1048271elaterites
laterite8716331laterite_
laterizes18513011laterizes
alterities10411042alterities
attrites8311562_attrites
eateries8324312eateri_es
elaterite949722elaterite_
laborites1149252laborites
lacerates112413772lacerates
laetriles944662laetriles
lateritic1147882lateritic
laterize17613292laterize_
laterized1979902laterized
latrines8515002lat_rines
lazurites1844582lazurites
literates91415652literates
aerates74627493_a_erates
aeries64737783_a_eri_es
albertites1244873albertites
algerines1069083algerines
aliterates101510753aliterates
altercates1247553altercates
alterity1149843alterit_y
alternates1047873alternates
ankerites1348523ankerites
aperies9423203_aperi_es
arenites8917103_arenites
arteries8321483arteri_es
arteritis949753arteritis
attrite7311833_attrite_
attrited947373_attrited
attrits7310613_attrit_s
azurites1737283_azurites
bacterizes2347963bacterizes
bakelites1545993bakelites
bakeries14312193bakeri_es
barites94322333ba__rites
batteries11615113batteri_es
catamites1349363catamites
catenates11311813catenates
catteries11815523catteri_es
cauteries11615393cauteri_es
cauterizes2197993cauterizes
cerites94823433__cerites
clathrates1545273clathrates
coteries10422703coteri_es
dataries9314033datari_es
datelines1088853datelines
dolerites101410893dolerites
elaterids1046163elateri_ds
elaterins9410033elateri_ns
elateriums1244333elateriums
enteritis9411303enteritis
faeries104118993fa_eri_es
fakeries1559833fakeri_es
favorites1546583favorites
feteritas1264893feteritas
flaneries1249563flaneri_es
flatteries1347413flatteri_es
galenites10129183galenites
interties9320333interties
iterates81317823_iterates
jadeites1645823jade_ites
japeries17311463japeri_es
laborite10410693laborite_
lacerate102214703lacerate_
lacerated122210673lacerated
lacertids1244153lacertids
laetrile845193laetrile_
lakesides1444093lakesides
latencies1147773latencies
latents75214313late_nt_s
lateraled1047453lateraled
lateralizes2048433lateralizes
laterals8312753later_als
latests73910313late_st_s
latexes1438313late__xes
latices9313763lat__ices
latinities10410163latinities
latinizes18610153latinizes
latrias71913213lat_ri_as
latrine7715123lat_rine_
lattes65324203lat___tes
lattices1038383lat_tices
laureates987683laureates
layerages1345303layerages
layerings13235683layerings
layettes1136263laye_ttes
lazulites1844253lazulites
lazurite1745243lazurite_
legerities1196883legerities
lenites7818443l__enites
liberates111012943liberates
liberties1149203liberties
literate81216893literate_
literatus9146823literatus
liveries11314373liveri_es
lotteries9311073lotteri_es
macerates132113573macerates
maderizes2148953maderizes
masteries111018493masteri_es
matelotes1146333matelotes
materials11510793materials
materiel10311253materi_el
materiels1147833materiels
maternities1346013maternities
matrices12312083mat_rices
matrixes1738063mat_rixes
maturates11311763maturates
maturities1248453maturities
meteorites1247613meteorites
naperies10313903naperi_es
niteries8318383niteri_es
nitrites82313453nit_rites
outwrites1238233outwrites
paternities1345783paternities
patriates11311363pat_riates
preterites12411793preterites
rareripes1165353rareripes
ratites74920683rat__ites
satellites1045423satellites
satirises9410193satirises
satirizes1849393satirizes
saturates9811603saturates
sclerites1139443sclerites
siderites10410433siderites
slaveries1249683slaveri_es
sternites9310073_sternites
tergites9310543__tergites
termites10313693__termites
totemites1146603totemites
valerates12310543valerates
verites103822263__verites
wasteries121115343wasteri_es
waterages1349383waterages
waterier11312083wateri_er
wateriest12312233wateri_est
wateriness1348073wateriness
waterings13229253waterings
waterjets1944463waterjets
waterlines1348953waterlines
watersides1445533watersides
witherites1645973witherites
yperites13310153_yperites

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 Filter1786911486410.470380193.6
2DLD Change Limit1486411456.54622707.1
3Display Results1451450.0632301.6
 (SQL Overall)1786911457.07925242.4
 
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.