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

122 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
tambours125587(None) 
tabours94110091ta_bours
tambour1136351tambour_
tamboura1253891tamboura
tambouras1343491tambouras
tamburs11288611tamb_urs
amours83512662_am_ours
arbours93910042_arbours
harbours1346922harbours
labours9349892la_bours
sambhurs1543182sambhurs
samburs11369342samb_urs
tabors84517112ta_bo_rs
tabour84011322ta_bour_
tamboured1443782tamboured
tambourer1343492tambourer
tambourers1442742tambourers
tambourin1363612tambourin
tambourins1443482tambourins
tambur10358712tamb_ur_
tambura11326462tamb_ura
tamburas12316052tamb_uras
tumours976752tum_ours
ambeers11428923_ambeers
ambers104519583_amb_ers
amblers115213563_amblers
ambones11312683_ambones
ambos95321253_ambo__s
amour75014853_am_our_
arbors84717883_arbo_rs
arbour84211333_arbour_
ardours8368883_ardours
armours9389853_armours
bamboos1348753bambo_os
cambers134017443camb_ers
cambiums1644933cambiums
campouts1436823campouts
candours11408643candours
clamours1255993clam_ours
enamours1044663enam_ours
faitours1134263faitours
famous11412393fam_ou_s
faubourg1461693faubourg
faubourgs1541233faubourgs
favours13437093fa_vours
gambiers13337073gambiers
gambirs12359083gamb_irs
gamblers13369733gamblers
gamboges1435653gamboges
gambols1238593gambo_ls
glamours1184733glam_ours
hambones1539673hambones
hamburg1544123hamb_urg
hamburgs1643473hamb_urgs
harbors12412413harbo_rs
harbour1247053harbour_
haviours1443843haviours
humours1286433hum_ours
iambus10468903iamb_u_s
labors84016413la_bo_rs
labour84210933la_bour_
lambers113817113lamb_ers
mamboes135011823mambo_es
mambos125414493mambo__s
pandours11317993pandours
parlours1036153parlours
paviours1343613paviours
ramblers124010373ramblers
ramous8417113ram_ou_s
rancours1076713rancours
rumours976373rum_ours
sambars115113843samb_ars
sambhars1544833sambhars
sambhur1453083sambhur_
sambos104315193sambo__s
sambur10469503samb_ur_
santours837183santours
sapours93610623sa_pours
saviours1154273saviours
savours10389343sa_vours
tabers84621573ta_b_ers
taboos83815433ta_bo_os
tabor75518393ta_bo_r_
taborers10268333ta_borers
tabouli945843ta_bouli
taboulis1045043ta_boulis
taboured1156273ta_boured
tabourer1035743ta_bourer
tabourers1144673ta_bourers
tabouret1049173ta_bouret
tabourets1144163ta_bourets
tabuns8489223ta_b_uns
tabus74820923ta_b_u_s
tagboard1245563tagboard
tagboards1345133tagboards
tailors73212393tailo_rs
takeouts1245363takeouts
talcous939483talcou_s
tambacs13219363tamb_acs
tambaks15218153tamb_aks
tambalas1237033tambalas
tambourine1453133tambourine
tambourines1552223tambourines
tambouring1543803tambouring
tamers84224033tam__ers
tampers113516743tam_pers
tampons112711563tampo_ns
tandoors9258053tandoors
temblors1244463temblors
tenours72610073t_enours
timbers113111853timb_ers
timeous938403timeou_s
timeouts1044773timeouts
tombolas1246023tombolas
tombolos1245113tombolos
tomboys1435713tombo_ys
tours55325893t___ours
tumblers123110623tumblers
tumors8810613tum_o_rs
tumour8137403tum_our_
valours10248743va_lours
vapours12277463va_pours

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.826216332.9
2DLD Change Limit1461621228.67316852.5
3Display Results1221220.0462652.2
 (SQL Overall)1786911229.54518720.9
 
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.