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

185 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
templet11271200(None) 
temple102811331temple_
templed12278561templed
temples112610891temples
templets12226141templets
semple103212752semple_
temped113912892temp_ed
tempeh13357462temp_eh
temper103914092temp_er
tempest1139222tempest
templar1145642templar
template1238432template
tempt95124842temp__t
tempted12317282tempted
tempter11358212tempter
triplet94319212triplet
ample94720303_ample_
ampler104313303_ampler
amplest11312333_amplest
amulet8419573_amulet
applet105917433_applet
armlet84118193arm_let
bomblet13412263bomblet
camlet104426583cam_let
caplet104226813_caplet
chaplet14512253chaplet
compleat14710153compleat
complect1659013complect
complete143412053complete
complex2037243complex
complot13310683complot
couplet114717943couplet
deplete103010423de_plete
dimple113512793dimple_
dimpled132810303dimpled
dimples122813213dimples
droplet10312113droplet
eaglet73722583_eaglet
emblem1237583_emblem
emmet94221383_em_met
empale102611263_empale_
empaled12288953_empaled
empaler11288353_empaler
empales112411433_empales
employ1346493_employ
eyelet9514533_eyelet
female11310553female_
females12310663females
gimlet93716663gim_let
hamlet113722793ham_let
hempen1338963hemp_en
hempie132410563hempie_
hempier14319003hempier
hempiest1539033hempiest
impled113812513_impled
kempt134318463kemp__t
leaflet10199743leaflet
limpet103518633limp_et
nymphet1764323nymphet
omelet8317073_omelet
pamphlet1745733pamphlet
pellet83326553pe_llet
people10310193people_
peopled1238503peopled
peopler1138083peopler
peoples11312223peoples
perplex1836153perplex
pimple123512963pimple_
pimpled14289193pimpled
pimples133012423pimples
reflet94024233re_flet
reglet73724233re_glet
relet54749823re__let
remeet86325473rem_eet
remelt85123123remel_t
remet74843723rem__et
repled93319783re_pled
replete92912993re_plete
replot83818593re_plot
respelt9312143respelt
resplit9310373resplit
rimple103814583rimple_
rimpled123311423rimpled
rimples113114223rimples
ripplet113412583ripplet
rumple103913013rumple_
rumpled123810013rumpled
rumples113313133rumples
samlet84126563sam_let
sample104215013sample_
sampled123410793sampled
sampler113212013sampler
samples112815453samples
sempre102710093sempre_
septet8921133se_ptet
simple104315173simple_
simpler112910863simpler
simples113014943simples
simplest122310223simplest
simplex18256393simplex
steeple937323steeple_
steepled1135893steepled
steeples1038013steeples
sterlet71318473ste_rlet
tablet84227643t_ablet
tamale83717403tamale_
tamales93216153tamales
tamped114317043tamp_ed
tamper104618513tamp_er
tappet103820113t_appet
tartlet72218483tartlet
teapot8416763teap_ot
teazle15329553teazle_
teazled17326833teazled
teazles16308923teazles
teepee8314363teep_ee
teepees939263teepees
tele45040873te__le_
teles54536003te__les
telex125214823te__lex
teller63519813te_ller
telnet6518833te_lnet
telpher1235563telpher
temblor1144093temblor
temp85323333temp___
tempehs14325153tempehs
tempera11329043tempera
tempered13248223tempered
temperer12227723temperer
tempers113513013tempers
tempests1234443tempests
tempi94912203temp__i
temping122710693temping
templars1255263templars
templates1348273templates
tempo95214973temp__o
tempos103812293temp_os
temps95417133temp__s
tempters12257293tempters
tempts10439453temp_ts
tempura11295253tempura
tenet55542213te__net
tepee74724213te_p_ee
tepees84215243te_pees
tercelet1049883tercelet
tercet83624913te_rcet
terret63425623te_rret
tippet103917873t_ippet
tipple103411913tipple_
tippled12358393tippled
tippler11348343tippler
tipples112811253tipples
toilet66228093t_oilet
tonlet62924703t_onlet
topple104411323topple_
toppled12348843toppled
topples113111653topples
townlet1049733townlet
trample11299703trample_
trampled13247903trampled
trampler12278013trampler
tramples122610203tramples
tremble1138003tremble_
trembled1335253trembled
trembler1235363trembler
trembles1237353trembles
triolet73219523triolet
triple84215923triple_
tripled104113833tripled
triples94616873triples
triplets103510263triplets
triplex16447803triplex
trippet113714113trippet
trumpet113810723trump_et
tumble103215643tumble_
tumbled123412243tumbled
tumbler113412823tumbler
tumbles113816023tumbles
tummler11266613tummler
tumped114216233tump_ed
tumult839703tumul_t
veinlet101310573veinlet
wimple133611363wimple_
wimpled15338823wimpled
wimples143311173wimples

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.406440125.6
2DLD Change Limit1340271856.83019623.3
3Display Results1851850.0762434.2
 (SQL Overall)1786911857.31224438.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.