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

44 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
nametag104444(None) 
nametags1143091nametags
gametal1037602gametal
aceta74017353_aceta_
acetal84314903_acetal
ameba9312383_ameba_
amebae1049633_amebae
ameban1039103_ameban
amebas10311453_amebas
bimetal1138433bimetal
camera10313693camera_
camerae11312063camerae
cameral11311283cameral
cameras11313363cameras
gamelan10106653gamelan
gamete9313593gamet_e
gametes10312253gametes
gametic12310003gametic
hangtag1244533hangtag
meta65932413__meta_
metage93114453__metage
metal75427383__metal
name65637413name___
named85223063name__d
namely113711323name_ly
namer75622103name__r
namers84517333name_rs
names74833363name__s
namesake1443243namesake
naming93917893nam_ing
natal53921493na__tal
navette1036983navette
nepeta837893nepeta_
nepetas935943nepetas
nonmetal1049653nonmetal
nosebag1043673nosebag
numeral939083numeral
ragtag836643ra_gtag
ramenta9311183ramenta_
ramet75743143ramet__
ramets83517393ramet_s
retag63618413__retag
tapeta8310693tapeta_
tapetal938273tapetal

Search took 8 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.453394461.4
2DLD Change Limit134027447.17318684.9
3Display Results44440.0162750.0
 (SQL Overall)178691447.64223382.8
 
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.