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

(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
tetrameters135462(None) 
tetrameter1255201tetrameter_
tetramers1146462tetram__ers
aerometers1249483ae_rometers
decameters15156593de_cameters
dekameters17164863de_kameters
heptameters1853273heptameters
hexameters2244453he_xameters
octameters1444833oct_ameters
parameters1448123_parameters
pentameters1544493pentameters
perimeters1448603pe_rimeters
rotameters1245033rot_ameters
teamsters1135973te__amsters
telemeters1246683te_lemeters
tetramer1046813tetram__er_
tetramerous1353123tetramerous
trimeters1139213__trimeters
aerometer11410204ae_rometer_
altimeters1246354alt_imeters
atmometers1445874_atmometers
attracters1245114attra_cters
barometers14198514_barometers
betatters1134964bet_a_tters
betrayers1445014betra__yers
ceilometers1545514ceilometers
centimeters1544604centimeters
decameter14137364de_cameter_
decimeters15156684de_cimeters
dekameter16135104de_kameter_
dekametres17133604de_kametres
detractors13147294detra_ctors
diameters1247604__diameters
durometers1356374_durometers
dynameters1643794_dynameters
electrometers1765814electrometers
enamelers1144804_e_namelers
ergometers1345784_ergometers
fermenters15116534fe_r_menters
ferreters1246254fe_r_reters
geometers1238194ge__ometers
hectometers1846064hectometers
heliometers1646024heliometers
heptameter1753584heptameter_
hexameter2144854he_xameter_
hydrometers2095944hydrometers
hygrometers2084454hygrometers
metacenters1552484met_acenters
metameres1347454met_amere_s
metamers1249624met_am__ers
micrometers1749074micrometers
octameter1355014oct_ameter_
optometers1456744opt_ometers
orometers11310424__orometers
parameter1349124_parameter_
pedometers1547214pe_dometers
penetrometers1752774penetrometers
pentameter1445204pentameter_
perimeter1349564pe_rimeter_
potometers1449064pot_ometers
pyrometers1748334_pyrometers
ratemeters1244994rat_emeters
retracers11149554retra__cers
retractors12158584retra_ctors
retransfers1452614retransfers
retreaters1047544retr_eaters
retrievers1373304retr_ievers
rotameter1145444rot_ameter_
seamsters1136334se__amsters
spectrometers1953074spectrometers
spirometers1545804spirometers
tachometers1855074tachometers
taximeters1944054t_aximeters
teamakers1544874te__amakers
teamster1036294te__amster_
teaselers9165854te__aselers
teatasters1043884teata_sters
teeters74018304te____eters
telemeter1147284te_lemeter_
tellurometers15101874tellurometers
tempters12257294te___mpters
tenderometers1652714tenderometers
tensiometers1453864tensiometers
terabytes1443334te_rabyte_s
termers95414504te_r_m__ers
termites10313694te_r_mite_s
tetrahedra1452994tetrahe_dra
tetrameric1454314tetrame_ric
tetraspores1353564tetraspores
tetters74320474tet____ters
thermometers1964914thermometers
tiltmeters1244124t_iltmeters
titrates82314664titra__te_s
titrators948384titra__tors
tonometers1248114t_onometers
tormenters1245824t_or_menters
trammelers1442514__trammelers
trampers123210394__tram_pers
tramplers13305884__tramplers
travelers12266774__travelers
trimesters1245414__trimesters
trimeter10310084__trimeter_
trumpeters1442634__trumpeters
wattmeters1543604wat_tmeters

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.470380193.6
2DLD Change Limit1488191049.12316312.5
3Display Results1041040.0631650.8
 (SQL Overall)1786911049.65618505.7
 
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.