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

111 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
templar114564(None) 
templars1255261templars
exemplar1942332exemplar
tegular836602tegular
temblor1144092temblor
temper103914092temp_er
tempera11329042tempera
template1238432template
temple102811332templ_e
templed12278562templed
temples112610892temples
templet112712002templet
tempter11358212tempter
tempura11295252tempura
tumular9236542tumular
ampler104313303_ampler
cellar84514983ce_llar
embar94011603_em_bar
empale102611263_empale
empaler11288353_empaler
emplace1338263_emplace
emplane11410013_emplane
employ1346493_employ
exempla1842973exempla_
exemplars2042143exemplars
exemplary2351923exemplary
hamular1236973hamular
hempier14319003hempier
hexaplar2042253hexaplar
jemadar1743373jemadar
jemidar1744163jemidar
lempira1144193lempira
malar76424443__malar
medlar93010463me_dlar
molar75223093__molar
mylar105311533__mylar
nebular956483nebular
osmolar944483osmolar
pedlar93311273pe_dlar
peopler1138083peopler
pepla9312863pe_pla_
poplar103611113_poplar
premolar1246633premolar
regular838423regular
replan83215823re_plan
replay113412923re_play
sampler113212013sampler
secpar1037923secp_ar
secular92211533secular
seminar979763seminar
semple103212753sempl_e
similar937853similar
simpler112910863simpler
simular938673simular
stelar64013863ste__lar
stellar72610433ste_llar
tabular9279763tabular
talar56225383t__alar
tampala1136613tampala
tampalas1245473tampalas
tampan102512323tamp_an
tamper104618513tamp_er
tear45242883te___ar
tela45532973te__la_
telae54323293te__lae
teleplay1343073teleplay
teller63519823te_ller
telpher1235563telpher
temblors1244463temblors
temp85323333temp___
temped113912893temp_ed
tempeh13357463temp_eh
tempehs14325153tempehs
temperas12278233temperas
temperer12227723temperer
tempers113513013tempers
tempest1139223tempest
tempi94912203temp__i
temping122710693temping
templates1348273templates
templets12226143templets
tempo95214973temp__o
temporal1246333temporal
temporary1653203temporary
tempos103812293temp_os
temps95417133temp__s
tempt95124843temp__t
tempted12317283tempted
tempters12257293tempters
tempts10439453temp_ts
tempuras12295063tempuras
teopan839353teop_an
tepa66021683te_p_a_
tepal76319583te_p_al
tepals85415043te_pals
tepas76521683te_p_as
tephra1136483te_phra
tesla55612603te_sla_
teslas64212173te_slas
tippler11348343tippler
titular737523titular
tolar55524113t__olar
trampler12278013trampler
trembler1235363trembler
tubular9267473tubular
tumbler113412823tumbler
tummler11266613tummler
tutelar735373tutelar
tympan13257013tymp_an
velar85817633ve__lar
venular1037683venular

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.470380193.6
2DLD Change Limit1340271116.81319672.2
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.32924381.4
 
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.