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

60 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
metatag104505(None) 
metatags1144691metatags
meatal84114732me_atal
metate82720532metat_e
metates92720002metates
bemata10411693bemata_
betta74916843bet_ta_
bettas84913923bet_tas
getaway1444013getaway
hematal1238953hematal
jetlag1434523jet_lag
meat66359603me_at__
meated94222403me_ated
meatman1137903meatman
meats75034053me_at_s
meatus85112923me_atus
meaty107021313me_at_y
medaka1336343medaka_
medakas1435763medakas
megabar1244503megabar
megara9310093megara_
megastar1143533megastar
megaton10269843megaton
meltage1037953me_ltage
menta74424423me_nta_
mental84521603me_ntal
meta65932413me__ta_
metage93114453meta_ge
metages102714973metages
metal75427383me__tal
metaled102913873metaled
metaling111613713metaling
metals84520883meta_ls
metamer1139613metamer
metatarsi1143133metatarsi
metazoa1845543metazoa
metazoal1944473metazoal
metazoan1945083metazoan
metepa1066013metepa_
metepas1136303metepas
meterage1147923meterage
metical11315363metical
meting94320593met_ing
metopae1147743metopae
metring103215283metring
mettle83815723met_tle
mutate83017483mutat_e
mutated102712253mutated
mutates92215793mutates
mutating112211753mutating
ratatat7412263ratatat
reata54225393re_ata_
reatas64021013re_atas
retag63618413re__tag
retotal739843retotal
seabag938473se_abag
stalag7310023_stalag
statal61613223_statal
tatar56122063__tatar
tetanal738023tetanal

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027608.92315020.4
3Display Results60600.0302000.0
 (SQL Overall)178691609.10919617.0
 
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.