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

51 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
tamandu104443(None) 
tamandua1142591tamandua
tamandus1143941tamandus
tamanduas1242572tamanduas
tamarau9107062tamarau
aland65526413_aland_
alands75418373_alands
amadou977613_amadou
amend85717753_amend_
amends94713283_amends
ataman81013063ataman__
atamans9710433ataman_s
atman75520143atman__
atmans84413963atman_s
calando1037383calando
daman84821163daman__
damans94715983daman_s
demand104314253demand_
demands114311413demands
hamada1239923hama_da
ramada9310183rama_da
remand95618963remand_
remands104914883remands
tabanid1047333tabanid
tabanids1144963tabanids
tabard9313333tabard_
tabards10310383tabards
tamable11312853tamable
tamal73522623tama__l
tamale83717403tama_le
tamales93216153tamales
tamals84116633tama_ls
tamarao977593tamarao
tamaraus1096183tamaraus
tamari8313413tama_ri
tamarin9311923tamarin
tamarind1147023tamarind_
tamarinds1244163tamarinds
tamaris9413603tamaris
tamasha12125433tamasha
tamed85528513tam_ed_
taming94023433tamin_g
tampan102512323tampan__
tampans113310983tampan_s
tamped114317043tamped_
taxman15328613taxman__
tendu67216003t__endu
timarau975853timarau
toman75724053toman__
tomans85419133toman_s
wakanda1544013wakanda

Search took 7 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.406440125.6
2DLD Change Limit134027515.95322514.2
3Display Results51510.0331545.5
 (SQL Overall)178691516.39227955.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.