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

143 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
aerolite831505(None) 
aerolites9312581aerolites
aerolith1149831aerolith
acrolith1348452acrolith
aeroliths1245642aeroliths
aerolitic1149342aerolitic
areolate81014452areolate
natrolite948022natrolite
perlite9317322per_lite
saprolite1147832saprolite
zeolite1638902ze_olite
abrogate11129603abrogate
absolute1044483absolute
acolyte12157653a_colyte
aconite9315473a_conite
acroliths1445113acroliths
acrylate1347693acrylate
adroit7518793adro_it_
adroiter946193adro_iter
aeolian738623ae_olian
aerate64830553aer__ate
aerie54634603aer__i_e
aerobat9514473aerobat_
aerobats1049843aerobats
aerobe8412403aero__be
aerobia939463aerobi_a
aerobic11310213aerobi_c
aerobics1246833aerobics
aerobium1246303aerobium
aerodyne1244193aerodyne
aerology1238743aerology
aerometer11410203aerometer
aerophyte1747203aerophyte
aeroplane1146593aeroplane
aerosat7417183aerosat_
aerosats8411013aerosats
aerosolize1953433aerosolize
airlike11310333air_like
airline7315033air_line
ammonite1249143ammonite
amosite9313163a_mosite
anolyte10159003a_nolyte
apholate13410473apholate
aphrodite1545483aphrodite
aplite8316393a__plite
apposite12410013apposite
apronlike1543453apronlike
arecoline1147103arecoline
arenite71017713a_renite
areolae7811733areol_ae
areolated1089713areolated
areole61017283areol__e
armlike1348553a_rmlike
arrogate91210323arrogate
arrowlike1642423arrowlike
atrocity1347213atrocity
atropine10410113atropine
aurality1139223aurality
berline93716853ber_line
beryline1337083beryline
cenobite1246853cenobite
cerite84724873cer__ite
cerusite1047763cerusite
chromite15310833chromite
coprolite1348623coprolite
creolise1037863creolise
creolize1947183creolize
cryolite1347503cryolite
defoliate1346993defoliate
derogate10311353derogate
desolate9411993desolate
ebonite9310293_ebonite
egalite8311563_egalite
elite56230183_e__lite
eolith93013903_e_olith
eremite9312833_eremite
erosive1039193_erosive
erotize16311663_erotize
erudite838483_erudite
evolute1045683_evolute
farolito1155583farolito
ferlie92814053fer_li_e
fernlike1535243fernlike
ferocity1645993ferocity
ferrite103312753fer_rite
germlike1535093germlike
herblike1735883herblike
herdlike1636113herdlike
heroine103517483hero_ine
heroize193210963hero_ize
impolite1249293impolite
iolite63221983__iolite
jarosite1548383jarosite
kernite1159473ker_nite
kerosine1238143kerosine
kryolite1544493kryolite
marlite92917073mar_lite
melilite10410573melilite
merozoite2043323merozoite
natrolites1047413natrolites
neolith1068783ne_olith
neroli61111153neroli__
nerolis71012773neroli_s
oolite63319603__oolite
pearlite1039443pearlite
pelite84323003pe__lite
pemoline12310273pemoline
penlite9313243pe_nlite
percolate13411163percolate
perfoliate1555443perfoliate
perlites10316363per_lites
perorate10417923perorate
peroxide1848183peroxide
pisolite10310373pisolite
polite83625073__polite
prolate9419793_prolate
proline92321593_proline
pyrolize2248133pyrolize
regolith1247543regolith
reroute7313963rero_ute
resolute868513resolute
revolute1176793revolute
rhyolite1445513rhyolite
ruralite848963ruralite
saprolites1247053saprolites
sepiolite1146803sepiolite
serflike1536273serflike
serosity1148783serosity
serotine8313573serotine
siderolite1153913siderolite
staurolite1053193staurolite
tenorite8311993tenorite
tergite8311003ter_gite
termite9313893ter_mite
tremolite1156893tremolite
troilite849543_troilite
unpolite1049173unpolite
uralite71714103_uralite
urolith1048783_urolith
variolite1248083variolite
verite94323443ver__ite
xenolith1845653xenolith
zeolites1738383ze_olites

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.420425454.8
2DLD Change Limit1461621436.75021653.6
3Display Results1431430.0632269.8
 (SQL Overall)1786911437.23324705.0
 
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.