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 “tabaret” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

134 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
tabaret9271731(None) 
cabaret112519041cabaret
tabarets10287231tabarets
taboret92916111taboret
cabarets12268462cabarets
labret8320222lab_ret
lazaret16411782lazaret
tabard9313332tabar_d
tabarded1234742tabarded
tabards10310382tabards
tabered103311592tabered
tablet84227642tab_let
tabored102810562tabored
taborer9269292taborer
taborets10278062taborets
tabouret1049172tabouret
abaft10318063_aba_ft
abase76023483_abase_
abased96514993_abased
abaser86414343_abaser
abases85720773_abases
abate76627843_abate_
abated95918453_abated
abater85518123_abater
abates85825033_abates
abet610547943_ab__et
abort76133583_abor_t
aigret73720023_aigret
apart74330673_apar_t
aware86420023_aware_
barbet104427883__barbet
bare65460523__bare_
bared85144483__bared
barer74535803__barer
bares75457133__bares
barest85327693__barest
barret84930483ba_rret
beret74946363__beret
buret77444013__buret
cabernet12410763cabernet
cabinet11318903cabinet
cablet104429463cab_let
carburet12411113carburet
caret75360563__caret
cigaret10413003cigaret
claret84026573_claret
gabbart1248883gabbar_t
garret74426553ga_rret
imaret81121233_imaret
kabar114815553kabar__
kabars124513953kabar_s
labara83712893labar_a
labarum1166013labarum
labored102810243labored
laborer9249503laborer
labrets939363lab_rets
lazarets1744803lazarets
minaret9520683minaret
parapet11317643parapet
rabat72832223raba__t
rabbet103818653rab_bet
sabered103213023sabered
sabre74821503sab_re_
sabred95916533sab_red
sabres85520863sab_res
subarea939403subarea
tabanid1047333tabanid
tabbed114215363tab_bed
tabbied12297793tabbied
tabbies112913503tabbies
taber73825823tab__er
tabers84621573taber_s
tabes76033923tab__es
table75429603tab_le_
tabled94020043tab_led
tables84524893tab_les
tablets94714383tab_lets
tabooed10267383tabooed
tabor75518393tabor__
taborers10268333taborers
taborin92210453taborin
tabors84517113tabor_s
taboured1156273taboured
tabourer1035743tabourer
tabourets1144163tabourets
tabued94310403tab_ued
tacet75840023t__acet
tacket124627493ta_cket
taffarel1442563taffarel
takahe1335793takahe_
takahes1436173takahes
talar56225383talar__
talaria7412513talaria
talars66021683talar_s
tamale83717403tamale_
tamales93216153tamales
tamarao977593tamarao
tamarau9107063tamarau
tamari8313403tamar_i
tamarin9311913tamarin
tamaris9413593tamaris
tanager83010943tanager
tanbark1337373tanbar_k
tanbarks1445563tanbarks
tanrec837803ta_nrec
tapered102612933tapered
taperer92511793taperer
tappet103820113ta_ppet
tare45957623t__are_
tared69340053t__ared
tares57456563t__ares
target75028903ta_rget
tarot55943933t__arot
tarre55825633ta_rre_
tarred74720283ta_rred
tarres64723043ta_rres
tart47566183t__ar_t
tartare73012683tartare_
tartlet72218483tartlet
tasset65925313ta_sset
tatar56122063tatar__
tatars64619793tatar_s
teacart91113193teacar_t
teared75722153t_eared
tearer64822903t_earer
teaware1048143teaware_
teawares1148083teawares
terret63425623t_erret
thwart12311683thwar_t
tret46653533t___ret
tubae74716643tuba_e_
tubaist938703tubaist
tubate82813173tubate_
turret63121853t_urret

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.1561145455.1
2DLD Change Limit1340271346.43620824.6
3Display Results1341340.0462913.0
 (SQL Overall)1786911346.63826919.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.