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

89 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
backdate174822(None) 
backdated1946481backdated
backdates1848151backdates
baccate131011262bac_cate
backbite1899172backbite
backwater2096752backwater
acaudate1145973_acaudate
acerate92818913_acerate
acetate92514753_acetate
actuate9311443_actuate
acuate8315633_ac_uate
acylate12310533_acylate
airdate8311323_airdate
baccae12119703bac_ca_e
baccated15148383bac_cated
bacchante1844653bacchante
backache21126063backache
backbeat1847843backbeat_
backbeats1945763backbeats
backbit17129103backbit_
backbiter191786803backbiter
backbites19108633backbites
backbone1847443backbone
backcast1887673backcast
backcasts1985423backcasts
backchat2147113backchat_
backchats2245313backchats
backdating2045723backdating
backdoor1744693backdoor
backdraft2154703backdraft
backdrafts2252693backdrafts
backdrop19114253backdrop
backfire1946013backfire
backfit18108213backfit_
backfits19106953backfits
backhand2047433backhand
backhaul1945133backhaul
backhoe1847153back_hoe
backland1748103backland
backlash1945923backlash
backlit15911903backlit_
backout15612953backout_
backouts1698643backouts
backpack1945463backpack
backsaw1836203backsa_w
backsaws1946803backsaws
backseat1648903backseat_
backseats1746673backseats
backset15314193backset_
backsets1638853backsets
backside17108143backside
backspace2145083backspace
backstab1845453backstab
backstage1845423backstage
backstay1945963backstay
backward2048103backward
backwash2244943backwash
backwaters2195163backwaters
backyard2046843backyard
baldpate1345483baldpate
bandage11311023ba_ndage
bandmate1347973bandmate
banknote1444833banknote
barbate11314543ba_rbate
blackdamp2242563blackdamp
blackface2243423blackface
blackwater21103973blackwater
brachiate1646873brachiate
bracteate1345353bracteate
bunkmate1643963bunkmate
caudate10311353ca_udate
ecaudate1145313ecaudate
incudate1138873incudate
jackdaw2442843jackda_w
jackdaws2542923jackdaws
jaculate172311783jaculate
lacerate102214713lacerate
lactate9312703lac_tate
lacunate10128963lacunate
lapidate1157903lapidate
macerate122314073macerate
maculate122815623maculate
mandate10315573ma_ndate
package16128013pack_age
racemate1239063racemate
saccate111311763sac_cate
vacate11314553vac__ate
validate1239003validate
vanadate1245513vanadate

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 Filter1786911461620.436409841.7
2DLD Change Limit146162899.20615876.8
3Display Results89890.0461934.8
 (SQL Overall)178691899.68818444.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.