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

120 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
aerolites931258(None) 
aerolite8315051aerolite_
aeroliths1245641aeroliths
acroliths1445112acroliths
aerolith1149832aerolit_h
aerolitic1149342aerolitic
natrolites1047412natrolites
perlites10316362per_lites
saprolites1247052saprolites
zeolites1738382ze_olites
abrogates12108973abrogates
absolutes1144523absolutes
acolytes13168043a_colytes
aconites10314353a_conites
acrolith1348453acrolit_h
acrylates1446683acrylates
adroiter946193adro_iter
adroitest1044763adro_itest
aerates74627493aer__ates
aeries64737783aer__i_es
aerifies111313393aerifi_es
aerobats1049843aerobat_s
aerobes9311493aero__bes
aerobics1246833aerobi_cs
aerobioses1244493aerobioses
aerodynes1344603aerodynes
aerologies11312023aerologies
aerometer11410203aerometer
aerometers1249483aerometers
aerophytes1847153aerophytes
aeroplanes1246883aeroplanes
aerosats8411013aerosat_s
aerosolizes2053563aerosolizes
airlines8312793air_lines
ammonites1348143ammonites
amosites10311233a_mosites
anolytes11169213a_nolytes
apholates1449683apholates
aphrodites1644993aphrodites
aplites9314933a__plites
arecolines1246503arecolines
arenites8917103a_renites
areolate81014453areolate_
areolated1089713areolated
areoles71016953areol__es
arrogates10129423arrogates
atrocities1248593atrocities
atropines1148883atropines
auralities10410223auralities
berlines102315453ber_lines
cenobites1346203cenobites
cerites94823433cer__ites
cerusites1146523cerusites
chromites16310963chromites
coprolites1448223coprolites
creolises1157893creolises
creolizes2056583creolizes
cryolites1446963cryolites
defoliates1446333defoliates
derogates11310973derogates
desolates10311793desolates
ebonites1039233_ebonites
egalites9310503_egalites
elites66027123_e__lites
eoliths10318573_e_oliths
eremites10312603_eremites
erotizes17311213_erotizes
evolutes1156063_evolutes
farolitos1244053farolitos
ferlies103216693fer_li_es
ferocities1548243ferocities
ferrites112312833fer_rites
heroines112916573hero_ines
heroizes202610983hero_izes
iolites73819483__iolites
jarosites1647373jarosites
kernites1269113ker_nites
kerosines1357103kerosines
kryolites1643993kryolites
marlites103415263mar_lites
melilites1149193melilites
merozoites2142983merozoites
natrolite948023natrolite_
neoliths1144933ne_oliths
nerolis71012773neroli__s
oolites72817843__oolites
pearlites1138233pearlites
pelites93821993pe__lites
pemolines1348623pemolines
penlites10312273pe_nlites
percolates14410423percolates
perlite9317323per_lite_
perorates11417023perorates
peroxides1947493peroxides
pisolites1149383pisolites
prolines102619693_prolines
pyrolizes2347233pyrolizes
regoliths1344113regoliths
reroutes8312223rero_utes
resolutes968193resolutes
rhyolites1545033rhyolites
ruralites947943ruralites
saprolite1147833saprolite_
sepiolites1246013sepiolites
serosities10410823serosities
serotines9312073serotines
siderolites1253403siderolites
staurolites1152593staurolites
tenorites9311093tenorites
tergites9310543ter_gites
termites10313693ter_mites
tremolites1256053tremolites
troilites948433_troilites
uralites82112723_uralites
uroliths1154923_uroliths
variolites1346673variolites
velites103417303ve__lites
verites103822263ver__ites
xenoliths1943313xenoliths
zeolite1638903ze_olite_

Search took 9 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.453394461.4
2DLD Change Limit1486411207.87318879.8
3Display Results1201200.0462608.7
 (SQL Overall)1786911208.37221343.9
 
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.