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

143 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
templets1222614(None) 
temples112610891temple_s
templet112712001templet_
tempehs14325152temp_ehs
tempers113513012temp_ers
tempest1139222temp_est
tempests1234442tempests
templars1255262templars
template1238432template
templates1348272templates
temple102811332temple__
templed12278562temple_d
tempters12257292tempters
tempts10439452temp__ts
triplets103510262triplets
amplest11312333_amplest
amulets939923_amulets
applets115710063_applets
armlets94610063arm_lets
bomblets1436023bomblets
camlets114314623cam_lets
caplets114914523_caplets
chaplets1556883chaplets
complects1766413complects
complete143412053complete
completes153212923completes
complots1438163complots
couplets12389873couplets
deplete103010423de_plete
depletes112810643de_pletes
dimples122813213dimple_s
droplets1136063droplets
eaglets84111663_eaglets
emblems1335043_emblems
emmets10349153_em_mets
empalers12226743_empalers
empales112411433_empale_s
employs1455523_employs
empress1138163_empress
eyelets1057523_eyelets
females12310663female_s
gimlets10338433gim_lets
hamlets123211403ham_lets
helpless1335063helpless
hempiest1539023hempiest
humpless15226333humpless
leaflets11244813leaflets
limpets11329783limp_ets
nymphets1862703nymphets
omelets938333_omelets
pamphlets1842753pamphlets
pellets94014783pe_llets
peoplers1237163peoplers
peoples11312223people_s
pimples133012423pimple_s
pumpless14236373pumpless
reflets103513153re_flets
reglets83512983re_glets
relets64025673re__lets
remeets93712413rem_eets
remelts93511493remel_ts
replete92912993re_plete
repletes102812473re_pletes
replots93412633re_plots
resplits1037723resplits
rimples113114223rimple_s
ripplets12316733ripplets
rumples113313133rumple_s
rumpless12256543rumpless
samlets93813553sam_lets
samplers12299403samplers
samples112815453sample_s
semple103212753semple__
septets998953se_ptets
simples113014943simple_s
simplest122310223simplest
stampless1334543stampless
steeples1038013steeple_s
stemless1036653stem_less
sterlets8169273ste_rlets
tablets94714383t_ablets
tamales93216153tamale_s
tameless10259903tameless
tampers113516743tamp_ers
tappets113610013t_appets
tartlets8289663tartlets
teapots939053teap_ots
tearless848713tearless
teazles16308923teazle_s
teepees939263teep_ees
teles54536003te__le_s
tellers73717593te_llers
telnets738373te_lnets
telphers1335473telphers
temblors1244463temblors
temped113912893temp_e_d
tempeh13357463temp_e_h
temper103914093temp_e_r
tempera11329043temp_era
temperas12278233temperas
temperers13247023temperers
templar1145643templ_ar
tempos103812293temp__os
temps95417133temp___s
tempt95124843temp__t_
tempted12317283tempte_d
tempter11358213tempte_r
temptress1343133temptress
tempuras12295063tempuras
tenets65518953te__nets
tentless8229843tentless
tepees84215243te_p_ees
tercelets1144813tercelets
tercets93512443te_rcets
termless1036233termless
terrets72913583te_rrets
textless15245793textless
timeless10239543timeless
tipless92610063t_ipless
tippets11339373t_ippets
tipplers12336353tipplers
tipples112811253tipple_s
toilets74112913t_oilets
tombless1236783tombless
tonlets73212503t_onlets
topless92511123t_opless
topples113111653topple_s
townlets1134773townlets
tramplers13305883tramplers
tramples122610203trample_s
tremblers1334483tremblers
trembles1237353tremble_s
triolets83410143triolets
triples94616873triple_s
triplet94319213triplet_
trippets12357423trippets
trumpets12315573trump_ets
tumblers123110623tumblers
tumbles113816023tumble_s
tummlers12295703tummlers
tumults934823tumul_ts
veinlets11144833veinlets
wimples143311173wimple_s

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.420425454.8
2DLD Change Limit1461621437.19020328.5
3Display Results1431430.0632269.8
 (SQL Overall)1786911437.67323288.3
 
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.