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

96 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
tartrate89968(None) 
tartrated1096641tartrated
tartrates979561tartrates
bitartrate1252752bitartrate
castrate10313862castrate
narrate7313492nar_rate
tartare73012682tart_are
titrate72215572t_itrate
acerate92818913_acerate
actuate9311443_actuate
aerate64830553_a_erate
amirate91115953_amirate
arbitrate11137373_arbitrate
arcuate9311963_arcuate
artiste73813693_artiste
attrite7311833_attrite
aurate64426473_a_urate
barbate11314543bar_bate
barrage10710843bar_rage
barrater10310143bar_rater
birthrate1445303birthrate
bitartrates1352663bitartrates
carate84734003ca__rate
carinate103320253carinate
cartage10312593cart_age
castrated1239513castrated
castrater1148523castrater
castrates11312673castrates
castrati1048643castrati
castrato1048523castrato
cirrate92413493cir_rate
citrate92216803_citrate
cultrate10310873cultrate
curtate9312643curt_ate
ferrate103014043fer_rate
filtrate1148223filtrate
garrote8510103gar_rote
hastate10313913hast_ate
karate105320923ka__rate
lacerate102214713lacerate
lactate9312703lact_ate
lustrate8310443lustrate
macerate122314073macerate
margrave1444793margrave
marinate103017783marinate
maturate10312623maturate
narrated9310323nar_rated
narrater838723nar_rater
narrates8312763nar_rates
nitrate72017013_nitrate
outrate72323183_outrate
partake1339643part_ake
partite9317133part_ite
pastorate11411183pastorate
patriate10311933patriate
perorate10417923perorate
prorate9418733_prorate
rostrate8313843rostrate
satiate7315403sa_tiate
saturate8312813saturate
serrate73017543ser_rate
sororate8411173sororate
tabulate10310893tabulate
tailgate946823tailgate
tailrace1044883tailrace
tannate71813523ta_nnate
tantalate9107373tantalate
tantra63713353tantra__
tantras73112093tantra_s
tarre55825633tar_r__e
tartan64217513tart_a_n
tartana73010193tart_ana
tartans72615823tart_ans
tartar63214753tart_a_r
tartaric1047063tartaric
tartars73313403tart_ars
tartest72517533tartest_
tartlet72218483tartlet_
tartlets8289663tartlets
tartufe1064673tart_ufe
tartuffe1461903tartuffe
ternate7415483ter_nate
terrace93311843ter_race
terrae62915213ter_ra_e
terrane72814233ter_rane
testate73916233test_ate
titrated92611683t_itrated
titrates82314663t_itrates
tolerate8312323tolerate
torquate1745003torquate
trabeate1049483trabeate
tractate10411003tractate
triturate947483triturate
valerate11311473valerate
variate101316433var_iate
xanthate1845713xanthate

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 Filter1786911461620.406440125.6
2DLD Change Limit146162966.61022112.3
3Display Results96960.0462087.0
 (SQL Overall)178691967.06225303.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.