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

71 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
tartrated109663(None) 
tartrate899671tartrate_
tartrates979551tartrates
castrated1239512castrated
narrated9310322nar_rated
titrated92611682t_itrated
acerated113113983_acerated
actuated1138743_actuated
aerated85322373_a_erated
arbitrated13125523_arbitrated
arcuated1138803_arcuated
arrased8149863_ar_rased
arrayed11117153_ar_rayed
attracted1246073_attracted
attrited947373_attrited
aurated83817793_a_urated
barraged1297683bar_raged
barrater10310143bar_rater
bitartrate1252753bitartrate_
bitartrates1352653bitartrates
carinated123414263carinated
castrate10313863castrate_
castrater1148523castrater
castrates11312663castrates
citrated112712243_citrated
cultrated1248223cultrated
filtrated1345963filtrated
garreted1057523gar_reted
garroted1056783gar_roted
lacerated122210673lacerated
lactated1138863lact_ated
lariated91212063lar_iated
lustrated1037963lustrated
macerated142010523macerated
maltreated13125143maltreated
marinated122513173marinated
maturated1249163maturated
narrate7313493nar_rate_
narrater838723nar_rater
narrates8312753nar_rates
nitrated92213153_nitrated
outrated92219313_outrated
parroted1158843par_roted
patriated1238533patriated
perorated12412443perorated
portrayed1564103portrayed
prorated11513713_prorated
satiated9311603sa_tiated
saturated1038993saturated
serrated92513423ser_rated
tabulated1237303tabulated
tailgated1145123tailgated
targeted1037483tar_geted
tarred74720283tar_r__ed
tarried83914133tar_r_ied
tartare73012683tart_are_
tarted74923373ta__r_ted
tatted74920533ta_t__ted
terraced11318113ter_raced
threated1259203thr_eated
throated1247923thr_oated
titrate72215573t_itrate_
titrates82314643t_itrates
tolerated1049123tolerated
trabeated1246843trabeated
treated83618703t_r_eated
tritiated1047523tritiated
triturated1145073triturated
turreted935373tur_reted
variated121211393var_iated
warranted1345013war_ranted

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 Filter1786911486410.1731032896.0
2DLD Change Limit148641719.25016069.3
3Display Results71710.0332151.5
 (SQL Overall)178691719.45618897.1
 
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.