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

269 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
treacle93997(None) 
treacles1039701treacles
treacly1237091treacly
treadle8310101treadle
oracle84313292or_acle
teazle15329552t_eazle
trace75829612tr_ac_e
trachle12311852tr_achle
treaclier1144152treaclier
treadled1067122treadled
treadler936862treadler
treadles939702treadles
treble8311662tre_ble
treddle936432treddle
tremble1138002tremble
trestle72611362trestle
triable92515392triable
arable81821003ar_able
areae55229743area__e
areal55928733area_l_
areally10411243areally
areole61017283are_ole
article9310923article
atremble1244113atremble
barnacle1245943barnacle
beadle93314683_beadle
beagle93612593_beagle
brace95629273br_ac_e
breach134213723breac_h
breached163411643breached
breacher153011503breacher
breaches153714123breaches
breathe123711843breathe
cenacle1139123cenacle
coracle112011723coracle
crackle153611253cr_ackle
cradle93313163cr_adle
crease85519573crea_se
create85126383crea_te
creche13310763cre_che
creole8913723cre_ole
crevalle1346163crevalle
debacle1237443debacle
dryable13237433dryable
dyeable1337303dyeable
eagle64219483__eagle
errable9312183errable
eyeable1239063eyeable
fireable131710223fireable
freckle16106643freckle
friable122612563friable
fryable15277463fryable
grace85124543gr_ac_e
gracile102512603gr_acile
grackle14338893gr_ackle
grease75416233grea_se
greatly1137613greatly
greave104611493grea_ve
hireable13139083hireable
kleagle1242933kleagle
macle96127003__macle
manacle11310283manacle
measle83513223_measle
miracle1138843miracle
orache114013593or_ache
oracles93212423or_acles
peace95026083_peac_e
percale11314093percale
preach133613923preac_h
preached163412063preached
preacher153211373preacher
preaches153214893preaches
preachy17307313preachy
preact103220393preac_t
preacted132710943preacted
preacts113211363preacts
preamble1436383preamble
preface14510923prefac_e
prefile123413183prefile
prerace11414123prerac_e
presale9416353presale
race66746263_r_ac_e
rackle123917293_r_ackle
rale45050563_r_a_le
reach105123883_reac_h
reached134619083_reached
reacher123718293_reacher
reaches123423203_reaches
react74634333_reac_t
reacted103015713_reacted
reacts83616603_reacts
real45750293_rea_l_
realer63528593_rea_ler
reales64934123_rea_les
really93315613_really
realm75621623_rea_lm
reals55038653_rea_ls
reave84528023_rea_ve
recall83815723_recall
recane83022873_recane
recce9514563_re_cce
recycle1445343_recycle
reddle83815913_reddle
reface113616353_refac_e
refile95122373_refile
regale74821453_regale
relace83122153_relac_e
resale64025543_resale
rescale93215473_rescale
rescue8313003_rescue
resile64627673_resile
resole64624183_resole
retable91820403_retable
retackle1445043_retackle
reticle94112623_reticle
retile65929673_retile
revile94921613_revile
seeable91113943seeable
streamlet1146043streamlet
table75429603t__able
tace65342513t__ac_e
tache106222373t__ache
tackle123815733t__ackle
takable13310193takable
takeable1437463takeable
tale46154163t__a_le
tamable11312853tamable
tamale83717403tama_le
tameable1238603tameable
tapeable1238823tapeable
taxable1639073taxable
teacake1335453t_eacake
teach105221123t_eac_h
teacher123714833t_eacher
teaches122718353t_eaches
teacup1036253t_eacup
teal45546503t_ea_l_
teals56234133t_ea_ls
tease55428713t_ea_se
teasel63914983t_easel
teazel15368543t_eazel
teazled17326833t_eazled
teazles16308923t_eazles
tele45040873t_e__le
temple102811333t_emple
tenable93214493tenable
tenace82715693tenac_e
tentacle1037693tentacle
terce75721843t_erc_e
tercel83612993t_ercel
terrace93311843terrac_e
theatre10358493theatre
thecae11299653the_cae
thecal113310303thecal_
thecate123210023thecate
thence112010843thenc_e
tierce8339843tierc_e
tiercel9316203tiercel
totable92313363totable
toteable1048353toteable
towable121910113towable
traceable1338323traceable
traced94821583tr_aced
tracer84820233tr_acer
traces85329933tr_aces
trachea12311673tr_achea
trachled1438313tr_achled
trachles13311753tr_achles
track114823013tr_ac_k
tracked143716133tr_acked
tracker133515173tr_acker
tracks124818843tr_acks
tract75635713tr_ac_t
tractile10311073tr_actile
tracts85019073tr_acts
tradable1139873tradable
trade65026043tr_a_de
tradeable1247413tradeable
trail55126773tr_ail_
trailed83415673tr_ailed
trailer73015393tr_ailer
trails64622513tr_ails
tramel84113713tr_amel
trample11299703trample
trance84718763tr_ance
tranche123312223tranche
trauchle1344963trauchle
trave85223033tr_a_ve
travel94112983tr_avel
trawl84915873tr_awl_
trawled113411523tr_awled
trawler104011903tr_awler
trawley13317303tr_awley
trawls94412393tr_awls
treachery1744693treachery
treacliest1245383treacliest
tread64821703trea__d
treaded95014283treaded
treader84113833treader
treadlers1045893treadlers
treadless1036003treadless
treads74817923trea_ds
treason748763treason
treasure846753treasure
treat56240353trea__t
treatable1139323treatable
treated83618703treated
treater74219833treater
treaties8316983treaties
treatise8311103treatise
treats64821693trea_ts
treaty94414353trea_ty
trebled1038483tre_bled
trebles9311443tre_bles
trebly1138973tre_bly
treddled1134473treddled
treddles1036263treddles
tree47745813tre___e
trehala1045953trehala
trembled1335253trembled
trembler1235363trembler
trembles1237353trembles
trembly1435523trembly
tremolo946513tremolo
trenail7410813trenail_
trenails869843trenails
trench114211613trenc_h
trenched14289853trenched
trencher13279313trencher
trenches133512603trenches
tressel73010893tressel
trestles83012553trestles
trevally1446343trevally
triac74116373triac__
triacid1038593triacid
triacs83913223triac_s
triage72812893tria_ge
trial54926353tria_l_
trials64319883tria_ls
triangle935533triangle
triazole1744153triazole
trice75127493tr_ic_e
trickle133613443trickle
tricycle1543893tricycle
trifle94012883tr_ifle
trindle83311363trindle
triple84215923tr_iple
triscele1045433triscele
troche113112513tr_oche
trouble957713trouble
truce75118693tr_uc_e
truckle13358863truckle
truffle1384893truffle
trundle8307873trundle
tubercle1244413tubercle
tunable92511313tunable
tuneable1038913tuneable
tunicle9308033tunicle
turnable1037853turnable
tweedle1134193tweedle
typable1435883typable
typeable1535233typeable
ureal56722683urea_l_
urease64516993urea_se
useable9911063useable
utricle937913utr_icle
vernacle1345583vernacle
wreathe13339053wreathe
wrestle10298843wrestle

Search took 7 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.1401276364.3
2DLD Change Limit1340272696.73619897.1
3Display Results2692690.0932892.5
 (SQL Overall)1786912696.96925640.8
 
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.