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

48 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
metameres134745(None) 
metamere1257351metamere_
metamers1249621metamer_s
etageres936862_etageres
mesomeres1347192mesomeres
metamer1139612metamer__
metameric1546202metameric
metamerism1354772metamerism
antimeres11410893antimeres
defamers14258523defamer_s
dekametres17133603dekametres
ectomeres1346253ectomeres
epimeres12117653_epimeres
etagere836533_etagere_
etamines101611813_etamines
hetaeras1146733heta_eras
ketamines15177033ketamines
mameyes14376983m__ameyes
meaners94415243me_aner_s
measures1038913me_asures
megatheres1644853megatheres
melamines1339763melamines
menacers12279313menacer_s
menageries1345853menageries
mentaleses1245953mentaleses
mesomere1247193mesomere_
metages102714973meta__ges
metalises11315073metalises
metalizes20414243metalizes
metalmarks1852403metalmarks
metalwares1543653metalwares
metamerisms1453903metamerisms
metates92720013meta__tes
metatheses1544473metatheses
metered103514013met__ered
meters85625833met__er_s
metiers93312843met_ier_s
metres85121563met___res
pentameries1554753pentameries
reamers94221083re_amer_s
retakers123511133retaker_s
seamers94719433se_amer_s
steamered1244913steamered
steamers103410873steamer_s
tamers84224033__tamer_s
telomeres1146363telomeres
tetramers1146463tetramer_s
vitamers1334683vitamer_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 Filter1786911486410.1731032896.0
2DLD Change Limit148641488.34317816.3
3Display Results48480.0163000.0
 (SQL Overall)178691488.53220943.6
 
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.