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 “aerogels” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

71 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
aerogels94559(None) 
aerogel836521aerogel_
acrogens1147242acrogens
aerobes9311492aerobe_s
aerosols847212aerosols
kerogens1345762kerogens
aasvogels135943aasvogels
acrogen1038203acroge_n
aerates74627493aerate_s
aerials74017553aer_ials
aeries64737783aer_ie_s
aerobats1049843aerobats
aerobe8412403aerobe__
aerobics1246833aerobics
aerofoils1243393aerofoils
aerogram1149523aerogram
aerograms1248153aerograms
aeropulse1142533aeropulse
aerosats8411013aerosats
aerosol747683aerosol_
aerugos834923aerug_os
androgens1145253androgens
angels74416173a__ngels
apogees1037103a_pogees
areoles71016953areole_s
argals75517713a_r_gals
argils75213623a_r_gils
argles75218483a_r_gles
argols74514613a_r_gols
ariels65119373a_r_iels
artels66216233a_r_tels
averagely1642813averagely
averages1249183average_s
coronels104012153coronels
erodes74819883_erode_s
erosely1038083_erosely
eroses65327063_erose_s
exogens1536883_exogens
ferrels10248623fer_rels
grovels11427813_grovels
heroes94923833hero_e_s
hydrogels1764333hydrogels
kernels11417953ker_nels
kerogen1236093keroge_n
mergees104411233mer_gees
mergers103813423mer_gers
merges94122493mer_ge_s
nerols6914893nero__ls
oenomels1044583oenomels
perigees1189503perigees
petronels1146063petronels
propels113412843_propels
pyrogens1437293pyrogens
remodels1135673remodels
rerolls739943rero_lls
rogers74517913__rogers
rowels94515453__rowels
sapropels1343643sapropels
sergers83815633ser_gers
serges74225973ser_ge_s
tercels94110363ter_cels
trowels10358363_trowels
vergers114412633ver_gers
verges104320183ver_ge_s
wergeld1233183wer_geld
wergelds1342293wer_gelds
wergelt1138583wer_gelt
wergelts1253413wer_gelts
xeroses143612833xerose_s
xeroxes13246443xeroxe_s
zeroes154314343zero_e_s

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 Filter1786911461620.436409841.7
2DLD Change Limit146162717.90618487.5
3Display Results71710.0332151.5
 (SQL Overall)178691718.37521336.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.