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

121 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
tambura1132646(None) 
tamboura1253881tamboura
tambur10358711tambur_
tamburas12316041tamburas
tamburs11288601tamburs
hamburg1544122hamburg
sambuca1344342sambuca
sambur10469502sambur_
samburs11369342samburs
tambala1138022tambala
tambour1136342tambour_
tambouras1343472tambouras
tambours1255862tambours
tempura11295252tempura
ambari103012163_ambari
ambary134010543_ambary
amber94523213_amber_
ambers104519573_ambers
ambery133811133_ambery
ambry123512103_amb_ry
ambush1336113_ambush
amour75014853_amour_
amours83512643_amours
auburn836213_auburn
aura45836253_a__ura
bura66139533___bura
caesura956223caesura
camber124418473camber_
cambers134017433cambers
cambia124913153camb_ia
camera10313673cam_era
camorra11115763camorra
carbora11310703carbora
datura738023da_tura
gamba106018513gamb__a
gambia115912243gamb_ia
gambir11509763gambir_
gambirs12359083gambirs
gambusia1343573gambusia
hamburgs1643463hamburgs
homburg1543073homburg
iambus10468903iambu_s
katsura1143753katsura
labara83712893la_bara
labra75415463la_b_ra
lambada1245643lambada
lambda1146113lamb_da
lamber104418493lamber_
lambers113817103lambers
lambert113617113lambert
laura54116203la__ura
mamba116317523mamb__a
mbira977973__mbira
mura65633293__m_ura
pandura1037143pandura
parura8310583pa_rura
rambla103510933ramb_la
rambutan1243403rambutan
rasbora945943rasbora
sabra75317853sa_b_ra
samara8313853sam_ara
samba95618773samb__a
sambar103914163sambar_
sambars115113843sambars
sambhar1444853sambhar
sambhur1453083sambhur_
sambhurs1543183sambhurs
sambucas1444163sambucas
sambuke1544203sambuke
samsara936913samsara
samurai945923sam_urai
tabard9313333ta_bard
taber73825823ta_ber_
tabers84621573ta_bers
tabla73318363ta_b_la
tabor75518393ta_bor_
tabors84517093ta_bors
tabour84011313tabour_
tabours94110073tabours
tabu66328493ta_bu__
tabued94310403ta_bued
tabular9279763ta_bular
tabuli839363ta_buli
tabun75914373ta_bu_n
tabuns8489223ta_buns
tabus74820923ta_bu_s
taluka10426773ta_luka
tamarao977583tam_arao
tamarau9107053tam_arau
tamari8313383tam_ari
tamasha12125423tamasha
tambac122210243tamb_ac
tambacs13219363tambacs
tambak14249263tamb_ak
tambaks15218153tambaks
tambalas1237033tambalas
tamboured1443783tamboured
tambourer1343493tambourer
tambourin1363613tambourin
tamer75230103tam_er_
tamers84224033tam_ers
tampala1136613tampala
tamper104618513tamper_
tampers113516743tampers
tanbark1337373tanbark
tantara72410813tantara
tantra63713353ta_ntra
tarbush1234173tarbush
tempera11329043tempera
tempuras12295063tempuras
tilbury1242973tilbury
timber104012683timber_
timbers113111843timbers
timbery14256893timbery
timbral11237193timb_ral
timbre10328633timb_re
tombola1146093tombola
tumour8137393tumour_
tumours976733tumours
umbra948513_umb_ra
zamarra1843783zamarra

Search took 9 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 Limit1340271218.17316398.8
3Display Results1211210.0462630.4
 (SQL Overall)1786911218.37521336.2
 
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.