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

128 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
tambour113635(None) 
tabour84011321ta_bour
tamboura1253891tamboura
tambours1255871tambours
tambur10358711tamb_ur
amour75014852_am_our
arbour84211332_arbour
harbour1247052harbour
labour84210932la_bour
sambhur1453082sambhur
sambur10469502samb_ur
tabor75518392ta_bo_r
tabours94110092ta_bours
tambouras1343492tambouras
tamboured1443782tamboured
tambourer1343492tambourer
tambourin1363612tambourin
tambura11326462tamb_ura
tamburs11288612tamb_urs
tumour8137402tum_our
about75229083_a_bout
ambeer104511603_ambeer
amber94523213_amb_er
ambler104916453_ambler
ambo88225143_ambo__
ambos95321253_ambo_s
amours83512663_am_ours
arbor74818113_arbo_r
arbours93910043_arbours
ardour74110903_ardour
armour84411853_armour
bamboo12310013bambo_o
bamboos1348753bamboos
camber124418483camb_er
cambium1537323cambium
campout13412853campout
candour104210243candour
clamour1196333clam_our
enamour945433enam_our
faitour1034883faitour
famous11412393fam_ous
faubourg1461693faubourg
favour12438333fa_vour
gambier124711973gambier
gambir11509773gamb_ir
gambler123612683gambler
gamboge1335583gamboge
gambol1138223gambo_l
gambols1238593gambols
glamour1065133glam_our
hambone1439313hambone
hamburg1544123hamb_urg
harbor11410723harbo_r
harbours1346923harbours
haviour1354823haviour
humour11116753hum_our
iambus10468903iamb_us
labor75117313la_bo_r
labours9349893la_bours
lamber104418493lamb_er
lambier113611643lambier
mambo115215743mambo__
mamboed14417623mamboed
mamboes135011823mamboes
mambos125414493mambo_s
pandour10408213pandour
parlour937263parlour
paviour1244623paviour
rambler113313263rambler
ramous8417113ram_ous
rancour987133rancour
rumour8127383rum_our
sambar103914163samb_ar
sambhar1444853sambhar
sambhurs1543183sambhurs
sambo95118013sambo__
sambos104315193sambo_s
samburs11369343samb_urs
santour737373santour
sapour83812373sa_pour
saviour1035213saviour
savour94110703sa_vour
taber73825823ta_b_er
taboo73418093ta_bo_o
taboos83815433ta_boos
taborer9269293ta_borer
tabors84517113ta_bors
tabouli945843ta_bouli
taboured1156273ta_boured
tabourer1035743ta_bourer
tabouret1049173ta_bouret
tabu66328493ta_b_u_
tabun75914373ta_b_un
tabus74820923ta_b_us
tagboard1245563tagboard
tailor63412503tailo_r
takeout1149873takeout
talcous939483talcous
tambac122210243tamb_ac
tambacs13219363tambacs
tambak14249263tamb_ak
tambaks15218153tambaks
tambala1138023tambala
tambourers1442743tambourers
tambourine1453133tambourine
tambouring1543803tambouring
tambourins1443483tambourins
tamburas12316053tamb_uras
tamer75230103tam__er
tamper104618513tam_per
tampon102911233tampo_n
tampons112711563tampons
tandoor8278563tandoor
temblor1144093temblor
tenour62610733t_enour
timber104012683timb_er
timeous938403timeous
timeout948593timeout
tombola1146103tombola
tombolo1146103tombolo
tomboy1358213tombo_y
tomboys1435713tomboys
tour45530383t___our
tumbler113412823tumbler
tumor71110693tum_o_r
tumours976753tum_ours
valour93010373va_lour
vapour11378873va_pour

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 Filter1786911340270.453394461.4
2DLD Change Limit1340271286.61020276.4
3Display Results1281280.0304266.7
 (SQL Overall)1786911287.09325192.6
 
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.