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

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

85 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
templars125526(None) 
templar1145641templar_
exemplars2042142exemplars
temblors1244462temblors
temperas12278232temperas
tempers113513012temp_ers
template1238432template
templates1348272templates
temples112610892templ_es
templets12226142templets
tempters12257292tempters
tempuras12295062tempuras
cellars93713693ce_llars
embars103812883_em_bars
empalers12226743_empalers
empales112411433_empales
emplace1338263_emplace
emplaces1438413_emplaces
emplane11410013_emplane
emplanes1239503_emplanes
employs1455523_employs
exemplar1942333exemplar_
exemplary2351923exemplary
jemadars1842543jemadars
jemidars1843423jemidars
lempiras1243853lempiras
malars85020683__malars
medlars10259443me_dlars
molars85517323__molars
mylars114310443__mylars
pedlars103210213pe_dlars
peoplers1237163peoplers
poplars113910333_poplars
premolars1345023premolars
regulars936253regulars
replans92814943re_plans
replays12399763re_plays
samplers12299403samplers
secpars1138413secp_ars
seculars10219393seculars
seminars1079053seminars
simulars1047073simulars
talars66021683t__alars
tampalas1245473tampalas
tampans113310983tamp_ans
tampers113516743tamp_ers
tears55436463te___ars
tegular836603tegular_
teleplays1442713teleplays
tellers73717593te_llers
telphers1335473telphers
temblor1144093temblor_
temblores1344003temblores
tempehs14325153temp_ehs
temper103914093temp_er_
tempera11329043temp_era
temperers13247023temperers
tempests1234443tempests
temple102811333templ__e
templed12278563templ_ed
templet112712003templ_et
temporal1246333temporal
temporals1345293temporals
temporary1653203temporary
tempos103812293temp__os
temps95417133temp___s
tempter11358213tempter_
tempts10439453temp__ts
tempura11295253temp_ura
teopans939203teop_ans
tepals85415043te_p_als
tepas76521683te_p_a_s
tephras1236283te_phras
teslas64212173te_sla_s
tipplers12336353tipplers
titulars845863titulars
tolars64817943t__olars
tramplers13305883tramplers
tremblers1334483tremblers
tumblers123110623tumblers
tummlers12295703tummlers
tumular9236543tumular_
tutelars844993tutelars
tympans14236813tymp_ans
velars93913723ve__lars

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 Filter1786911461620.423422437.4
2DLD Change Limit146162857.43619656.0
3Display Results85850.0332575.8
 (SQL Overall)178691857.89222642.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.