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

287 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
treadle831010(None) 
treacle939971treacle
treadled1067121treadled
treadler936861treadler
treadles939701treadles
treddle936431treddle
beadle93314682_beadle
cradle93313162cr_adle
reddle83815912_reddle
teazle15329552t_eazle
trade65026042tr_ad_e
treacles1039702treacles
treacly1237092treacly
tread64821702tread__
treaded95014282treaded
treader84113832treader
treadlers1045892treadlers
treadless1036002treadless
treads74817922tread_s
treble8311662tre_ble
treddled1134472treddled
treddles1036262treddles
tremble1138002tremble
trestle72611362trestle
triable92515392triable
trindle83311362trindle
trundle8307872trundle
tweedle1134192tweedle
arable81821003ar_able
arcade91013643arcad_e
areae55229743area__e
areal55928733area_l_
areally10411243areally
areole61017283are_ole
atremble1244113atremble
beadles103414733_beadles
beagle93612593_beagle
bread85523113bread__
breaded115014063breaded
breadless1235943breadless
breadline1246273breadline
breads95419203bread_s
breadth1365993breadth
bready124511183bread_y
breathe123711843breathe
brede85520503bre_d_e
bridle94115463br_idle
brindle104210103brindle
broadly1337153broadly
cradled113410813cr_adled
cradler102910513cr_adler
cradles103114133cr_adles
crease85519573crea_se
create85126383crea_te
credal9311673credal_
creole8913733cre_ole
crevalle1346163crevalle
deadly113811473_deadly
dread74419023dread__
dreaded103612023dreaded
dreads84115023dread_s
dredge9308563dre_dge
dreidel934473dreidel
dreidl835233dreidl_
dreidls934053dreidls
dryable13237433dryable
dyeable1337303dyeable
eagle64219483__eagle
errable9312183errable
eyeable1239063eyeable
fireable131710223fireable
freckle16106643freckle
friable122612563friable
fryable15277463fryable
grade75126093gr_ad_e
grease75416233grea_se
greatly1137613greatly
greave104611493grea_ve
grenade938413grenad_e
griddle1035503griddle
heddle114211163_heddle
hireable13139083hireable
irade65618153ir_ad_e
kleagle1242933kleagle
ladle66320443__ladle
measle83513223_measle
meddle103312763_meddle
needle73310613_needle
oracle84313293or_acle
oread64619603oread__
oreads73915773oread_s
oreide7311673oreid_e
padle84522343__padle
peddle103512823_peddle
preadult1146973preadult
preamble1436383preamble
prebade12310283prebad_e
predate10616893predate
prefade1339013prefad_e
prefile123413183prefile
prehandle1544533prehandle
premade12311443premad_e
presale9416353presale
raddle84816173_raddle
rale45050563_r_a_le
read55942533_read__
readable11313163_readable
readd74617133_read_d
readded103310733_readded
readds84111643_readds
reader73628293_reader
readied93316623_readied
readier83117423_readier
readies83324713_readies
readily11711403_readily
reads64835273_read_s
ready94821503_read_y
real45750293_rea_l_
realer63528593_rea_ler
reales64934123_rea_les
really93315613_really
realm75621623_rea_lm
reals55038653_rea_ls
reave84528023_rea_ve
redate74124683_redate
reddled102912323_reddled
reddles93315773_reddles
rede55037673_re_d_e
redleg839273_re_dleg
redly94217203_re_dly
redye94413473_re_dye
refile95122373_refile
regale74821453_regale
rehandle1246173_rehandle
remade94316983_remad_e
resaddle10115223_resaddle
resale64025543_resale
resile64627673_resile
resole64624183_resole
retable91820403_retable
retile65929673_retile
revile94921613_revile
riddle83915713_riddle
roadie72813813_roadie
ruddle83414203_ruddle
rundle73214233_rundle
seeable91113943seeable
straddle10186223straddle
streamlet1146043streamlet
table75429603t__able
takable13310193takable
takeable1437463takeable
tale46154163t__a_le
tamable11312853tamable
tamale83717403tama_le
tameable1238603tameable
tapeable1238823tapeable
taxable1639073taxable
teal45546503t_ea_l_
teals56234133t_ea_ls
tease55428713t_ea_se
teasel63914983t_easel
teazel15368543t_eazel
teazled17326833t_eazled
teazles16308923t_eazles
tele45040873t_e__le
temple102811333t_emple
tenable93214493tenable
theatre10358493theatre
thread105011093thread__
threaded1366323threaded
threader1256733threader
threadier1354473threadier
threadless1442473threadless
threadlike1841943threadlike
threads11419953thread_s
thready14435903thread_y
tirade7311693tirad_e
tiredly1136803tire_dly
toddle85811033t_oddle
toreador945003toreador
torsade837593torsad_e
totable92313363totable
toteable1048353toteable
towable121910113towable
trace75829613tr_a_ce
traceable1338323traceable
trachle12311853trachle
trad55630913tr_ad__
tradable1139873tradable
tradeable1247413tradeable
traded85717683tr_aded
trader75218763tr_ader
trades75724503tr_ades
traduce1036353tr_aduce
trail55126773tr_ail_
trailed83415673tr_ailed
trailer73015393tr_ailer
trails64622513tr_ails
tramel84113713tr_amel
trample11299703trample
trance84718763tr_ance
trave85223033tr_a_ve
travel94112983tr_avel
trawl84915873tr_awl_
trawled113411523tr_awled
trawler104011903tr_awler
trawley13317303tr_awley
trawls94412393tr_awls
treaclier1144153treaclier
treaders93311843treaders
treading103515333treading
treadling1137503treadling
treadmill1242383treadmill
treason748763treason
treasure846753treasure
treat56240353trea__t
treatable1139323treatable
treated83618703treated
treater74219833treater
treaties8316983treaties
treatise8311103treatise
treats64821693trea_ts
treaty94414353trea_ty
trebled1038483tre_bled
trebles9311443tre_bles
trebly1138973tre_bly
tree47745813tre___e
treed65626733treed__
trehala1045953trehala
trembled1335253trembled
trembler1235363trembler
trembles1237353trembles
trembly1435523trembly
tremolo946513tremolo
trenail7410813trenail_
trenails869843trenails
trend64817453trend__
trended94011763trended
trendier937913trendier
trendies9312213trendies
trendily1256443trendily
trends75513543trend_s
trendy10469603trend_y
tressel73010893tressel
trestles83012553trestles
trevally1446343trevally
triad65217723triad__
triadic1037833triadic
triads74513533triad_s
triage72812893tria_ge
trial54926353tria_l_
trials64319883tria_ls
triangle935533triangle
triazole1744153triazole
tribade1037293tribad_e
trickle133613443trickle
trifle94012883tr_ifle
trindled10388693trindled
trindles93211683trindles
triode75311893triod_e
triple84215923tr_iple
trode65322853tr_od_e
trouble957713trouble
truckle13358863truckle
trudge8318733tr_udge
truffle1384893truffle
trundled10306393trundled
trundler9256153trundler
trundles9278483trundles
tsade64311123t_sad_e
tunable92511313tunable
tuneable1038913tuneable
turnable1037853turnable
twaddle12245713twaddle
tweedled1332833tweedled
tweedles1234113tweedles
twiddle12305483twiddle
typable1435883typable
typeable1535233typeable
ureal56722683urea_l_
urease64516993urea_se
ureide7310363ureid_e
useable9911063useable
wheedle1434823wheedle
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.403443402.0
2DLD Change Limit1340272876.39320964.6
3Display Results2872870.1062707.5
 (SQL Overall)1786912876.90225889.7
 
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.