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

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

92 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
aeronomists135563(None) 
aeronomist1247741aeronomist_
agronomists1453791agronomists
aeronomies12118322aeronomi_es
agronomist1354992agronomist_
autonomists1355162autonomists
economists1446952_economists
ergonomists1473512_ergonomists
aeronomers1244453aeronom_ers
aeronomic1347963aeronomi__c
aeronomical1555333aeronomical
agronomies13135913agronomi_es
autonomist1247193autonomist_
bionomists1444903_bionomists
economises1446563_economises
economist1348883_economist_
ergonomist1374973_ergonomist_
exonumists1953153_exonumists
gastronomists1662693gastronomists
serologists12410123serologists
taphonomists1952403taphonomists
taxonomists2052833taxonomists
acropolises1554624acropolises
aerialists1089524aer_ialists
aerofoils1243394aerofo_i_ls
aerologies11312024aerologi_es
aeronauts975164aeron__auts
aeronomer1145684aeronom__er
aeronomy1346444aeronom___y
aerosolizes2053564aerosolizes
agonists9289834a_gon__ists
agronomic1445424agronomi__c
algologists1346144algologists
anatomists12116754a_natomists
animists103010634a___nimists
apologists1348884a_pologists
arborists1147454a_r_borists
arsonists947414a_r_sonists
astronomies1345964astronomi_es
atomists102610964a___tomists
atonalists1048494a_tonalists
autonomies1247954autonomi_es
bionomist1347114_bionomist_
ceramists1346724cer__amists
cetologists1449164cetologists
demonists1248704demon__ists
ecologists13310924_ecologists
economics1545904_economi_cs
economies1348624_economi_es
economise1346054_economis_e
economised1544204_economised
economizes2345374_economizes
enologists11310624_enologists
ergonomics1553164_ergonomi_cs
eroticists1278184_eroticists
exonumist1844424_exonumist_
fetologists1547994fetologists
frontlists1344524_frontlists
gastronomist1563374gastronomist_
gemologists1577884gemologists
geologists1279164ge_ologists
gnomists1145474___gnomists
hedonists1346054hedon__ists
horologists1548964horologists
ironists839294_iron__ists
metrologists1588834metrologists
monodists1247704__monodists
necrologists1547874necrologists
neologists1139774ne_ologists
neurologists1347644neurologists
noneconomists1762724noneconomists
orologists1149824_orologists
pedologists1548274pedologists
penologists1449594penologists
personalists1476504personalists
petrologists1559144petrologists
prologists13311174_prologists
prosodists1345944_prosodists
reformists1544124refo_rmists
serologist11413154serologist_
sexologists1947254sexologists
sodomists1255924__sodomists
synonymists1952614synonymists
taphonomist1853234taphonomist_
taxonomist1953624taxonomist_
tenorists948194te__norists
terrorists1085614ter_rorists
threnodists1551944threnodists
toponymists1852174toponymists
urologists1148414_urologists
virologists1546634virologists
zootomists2144434_zootomists

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819928.68617133.2
3Display Results92920.0462000.0
 (SQL Overall)178691929.15519518.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.