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

104 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
aerogel83652(None) 
aerogels945591aerogels
acrogen1038192acrogen
aerobe8412402aerobe_
aerobes9311492aerobes
aerosol747682aerosol
kerogen1236082kerogen
aasvogel124963aasvogel
acerose9310893acerose_
acrogens1147243acrogens
aerate64830553aerate_
aerated85322373aerated
aerates74627483aerates
aerial64625713aer_ial
aerie54634603aer_ie_
aeried74221863aer_ied
aerier64823153aer_ier
aeries64737783aer_ies
aero45435343aero___
aerobat9514473aerobat
aerobia939463aerobia
aerobic11310213aerobic
aerofoil1143723aerofoil
aerogram1149523aerogram
aerosat7417183aerosat
aerosols847213aerosols
aerugo735803aerug_o
aerugos834923aerugos
androgen1046313androgen
angel65019563a__ngel
apogeal1045613a_pogeal
apogee9312553a_pogee
aproned10311503aproned
areole61017283areole_
areoles71016953areoles
argal65023383a_r_gal
argil65116883a_r_gil
argle65421563a_r_gle
argol65317263a_r_gol
ariel55228973a_r_iel
arose55832083a_rose_
arrowed1148103arrowed
artel56122743a_r_tel
auroral7310473auroral
average1158853average_
averaged1356213averaged
averagely1642813averagely
averages1249183averages
berobed1238233berobed
berouged1235323berouged
coronel94515223coronel
erode64520993_erode_
eroded84313583_eroded
erodes74819883_erodes
erose55727273_erose_
erosely1038073_erosely
eroses65327053_eroses
exogen1436513_exogen
ferrel92810203fer_rel
grovel104310543_grovel
heroes94923823hero_es
hydrogel1644753hydrogel
kernel104010583ker_nel
kerogens1345763kerogens
merge84523683mer_ge_
merged104214943mer_ged
mergee94018133mer_gee
merger95016473mer_ger
merges94122483mer_ges
nerol51017813nero__l
oenomel946563oenomel
perigeal1147543perigeal
perigee101113383perigee
peroneal1049163peroneal
peroral9314793peroral
petronel1048143petronel
pirogen1038263pirogen
propel103714063_propel
pyrogen1337353pyrogen
remodel1038093remodel
reroll6412683rero_ll
rerose63320843rerose_
roger64521413__roger
rowel84721413__rowel
sapropel1244643sapropel
serge64727463ser_ge_
serged84118763ser_ged
serger73819733ser_ger
serges74225963ser_ges
serosal7311143serosal
tercel83612993ter_cel
tergal72912833ter_gal
trowel94211463_trowel
verge93419833ver_ge_
verged114815153ver_ged
verger104315693ver_ger
verges104320173ver_ges
wergeld1233183wer_geld
wergelt1138583wer_gelt
xeroses143612823xeroses
xeroxed14244513xeroxed
xeroxes13246443xeroxes
zeroed16409413zero_ed
zeroes154314343zero_es

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 Filter1786911340270.1601116818.8
2DLD Change Limit1340271047.25018486.5
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.45623966.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.