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

55 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
backdated194648(None) 
backdate1748221backdate_
backdates1848151backdates
baccated15148372bac_cated
backwater2096752backwater
acerated113113983_acerated
acetated112010683_acetated
actuated1138743_actuated
acylated1437873_acylated
baccate131011263bac_cate_
backbite1899173backbite_
backbiter191786803backbiter
backbites19108633backbites
backboned2045473backboned
backdating2045713backdating
backed155725723back___ed
backfired2144543backfired
backfitted2253253backfitted
backhand2047433backha_nd
backhanded23114663backhanded
backhauled2253243backhauled
backhoed2047003back_hoed
backland1748103backla_nd
backlashed22124283backlashed
backlisted1944503backlisted
backloaded2044493backloaded
backpacked2253743backpacked
backpedaled2351263backpedaled
backspaced2343463backspaced
backward2048103backwa_rd
backwashed25123763backwashed
backwaters2195163backwaters
backyard2046843backya_rd
baldpated1543823baldpated
bandaged1337313ba_ndaged
blackwater21103973blackwater
brachiated1844673brachiated
bracketed1855863brack_eted
bucketed1736763buck_eted
buckramed2043343buckramed
caudated1238063ca_udated
hacksawed2243013hacksawed
jacketed22146533jack_eted
jaculated19289053jaculated
lacerated122210673lacerated
lactated1138863lac_tated
lapidated1345673lapidated
macerated142010523macerated
maculated142411503maculated
mandated12310293ma_ndated
packaged18115753pack_aged
packeted17148283pack_eted
racketed15169123rack_eted
vacated1349353vac__ated
validated1446493validated

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641557.34620234.3
3Display Results55550.0301833.3
 (SQL Overall)178691557.53223724.2
 
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.