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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

63 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
tambourines155222(None) 
tambourine1453131tambourine_
tambourins1443481tambourin_s
taborines11238982ta_bo_rines
tambourin1363612tambourin__
tambouring1543802tambourin_g
taborine102510683ta_bo_rine_
taborins103310223ta_bo_rin_s
tabouring1245723ta_bourin_g
tambouras1343493tambour__as
tamboured1443783tambour__ed
tambourer1343493tambour__er
tambourers1442743tambour_ers
tambours1255873tambour___s
taurines8310553ta___urines
ambaries123312384_amb_ari_es
amberies122514684_amb_eri_es
amberinas1344614_amb_erinas
amboinas1246034_ambo__inas
ambones11312684_ambo___nes
ambries111614554_amb__ri_es
arborizes2088824_arbo_rizes
armouries1146244_armouri_es
atabrines1144464atab__rines
bournes93615024___bour_nes
carburises1445854carb_urises
carburizes2345184carb_urizes
dourines9311374___dourines
glamourizes2362424glam_ourizes
hambones1539674hambo___nes
harbouring1643604harbourin_g
jamborees2043274jambo_r_ees
laborites1149254la_bo_rites
labouring1236214la_bourin_g
limousines1242914lim_ousines
murines93718224__m__urines
savouries1245474sa_vouri_es
taborin92210454ta_bo_rin__
taboring113010194ta_bo_rin_g
taboulis1045044ta_bouli__s
taboured1156274ta_bour__ed
tabourer1035744ta_bour__er
tabourers1144674ta_bour_ers
tabouret1049174ta_bour__et
tabourets1144164ta_bour_ets
tabours94110094ta_bour___s
tacrines10310564ta___crines
tailorings1143434tailo_rings
tamarinds1244164tam__arinds
tamarins10310844tam__arin_s
tambour1136354tambour____
tamboura1253894tambour___a
tamburas12316054tamb_ur__as
tamburs11288614tamb_ur___s
tangerines1147544ta_ngerines
taurine7311364ta___urine_
temporises1447244tempo_rises
temporizes2346934tempo_rizes
tilburies1144344tilb_uri_es
timberings15124094timb_erings
timberlines1583284timberlines
tourings9277374t___ourings
trampolines1543904trampo_lines

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 Filter1786911488190.406440125.6
2DLD Change Limit148819638.11018350.1
3Display Results63630.0331909.1
 (SQL Overall)178691638.54920902.0
 
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.