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

260 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
treacles103970(None) 
treacle939971treacle_
treadles939701treadles
breaches153714122breaches
oracles93212422or_acles
preaches153214892preaches
reaches123423202_reaches
reales64934122_rea_les
teaches122718352t_eaches
teazles16308922t_eazles
traces85329932tr_ac_es
trachles13311752tr_achles
treaclier1144152treaclier
treacliest1245382treacliest
treacly1237092treacl_y
treadle8310102treadle_
treadled1067122treadled
treadler936862treadler
treadlers1045892treadlers
treadless1036002treadless
treaties8316982treaties
trebles9311442tre_bles
treddles1036262treddles
trembles1237352trembles
trenches133512602trenches
trestles83012552trestles
arables91814983ar_ables
areoles71016953are_oles
articles10310253articles
barnacles1355333barnacles
beaches144120653_beaches
beadles103414733_beadles
beagles103212123_beagles
bleaches153410673bleaches
braces108427773br_ac_es
braches144621223br_aches
breached163411643breached
breacher153011503breacher
breachers16369853breachers
breadless1235943breadless
breathes134212903breathes
breeches15258673breeches
broaches153211623broaches
cenacles1238023cenacles
coracles121811163coracles
crackles164111273cr_ackles
cradles103114133cr_adles
creases94020963crea_ses
creates95225203crea_tes
creches14313093cre_ches
creoles9913323cre_oles
crevalles1455723crevalles
debacles1335723debacles
dreamless1243513dreamless
drearies92313413drearies
drenches14309803drenches
eagles73819163__eagles
freckles17126383freckles
frenches163311633frenches
frescoes1357833frescoes
graces94523493gr_ac_es
graciles112511613gr_aciles
grackles15309183gr_ackles
greases84816713grea_ses
greaves113311443grea_ves
kleagles1343143kleagles
leaches123319343_leaches
macles107023223__macles
manacles1239523manacles
measles92412753_measles
miracles1238333miracles
oraches124216473or_aches
oracle84313293or_acle_
outreaches1545353outreaches
peaces106324083_peac_es
peaches144120053_peaches
percales12313803percales
pleaches153210433pleaches
preached163412063preached
preacher153211373preacher
preachers16339573preachers
preacted132710943preacted
preacts113211363preac_ts
preambles1545333preambles
prefaces15311063prefac_es
prefiles133113443prefiles
prelacies13310053prelacies
presales10315263presales
races74943243_r_ac_es
rales54947493_r_a_les
reached134619083_reached
reacher123718293_reacher
reachers133515723_reachers
reacted103015713_reacted
reacts83616603_reac_ts
readies83324713_readies
realer63528593_rea_ler
realest73322433_rea_lest
realms84913493_rea_lms
reals55038653_rea_l_s
reaves94127573_rea_ves
recalls92613623_recalls
recanes93222263_recanes
recces10614913_re_cces
recycles1535353_recycles
reddles93315773_reddles
refaces123216743_refac_es
refiles104122423_refiles
regales83520793_regales
relaces93420883_relac_es
resales74724903_resales
rescales103414573_rescales
rescues9312753_rescues
resiles74026543_resiles
resoles73823653_resoles
retables101712673_retables
retackles1545363_retackles
retches123318513_retches
reticles103912483_reticles
retiles74426993_retiles
reviles104421353_reviles
roaches123616213_roaches
streamlet1146043streamlet
streamlets1243073streamlets
stretches1438293stretches
tables84524893t__ables
taces76237803t__ac_es
taches114224173t__aches
tackles133816523t__ackles
tales55451373t__a_les
tamales93216153tama_les
taxables1734383taxables
teacakes1435883t_eacakes
teacher123714833t_eacher
teachers133212393t_eachers
teacups1133963t_eacups
teals56234133t_ea_l_s
tearless848713t_earless
teasels74311313t_easels
teases65426273t_ea_ses
teazels16406893t_eazels
teazle15329553t_eazle_
teazled17326833t_eazled
teles54536003t_e__les
temples112610893t_emples
tenaces92814513tenac_es
tenches123515523t_enches
tentacles1146713tentacles
tercels94110363t_ercels
terces83921413t_erc_es
terraces102712253terrac_es
theatres11298643theatres
threadless1442473threadless
tiercels10344753tiercels
tierces93710453tierc_es
trace75829613tr_ac_e_
traced94821583tr_ac_ed
traceless11228643tr_aceless
tracer84820233tr_ac_er
tracers94917843tr_acers
trachea12311683tr_achea
tracheas13410273tr_acheas
trachle12311853tr_achle_
trachled1438313tr_achled
tracked143716133tr_acked
tracker133515173tr_acker
trackers143512853tr_ackers
trackless15246723tr_ackless
tracks124818843tr_ac_ks
tracts85019073tr_ac_ts
trades75724503tr_a_des
trailed83415673tr_ailed
trailer73015393tr_ailer
trailers82912933tr_ailers
trails64622513tr_ail_s
tramels93812493tr_amels
tramless1037503tr_amless
tramples122610203tramples
trances93919643tr_ances
tranches132915513tranches
trapes85024463tr_a_pes
trashes104119263tr_ashes
trasses74819323tr_asses
trauchles1445493trauchles
travels104711293tr_avels
traves94222743tr_a_ves
trawled113411523tr_awled
trawler104011903tr_awler
trawlers113310203tr_awlers
trawley13317303tr_awley
trawleys14284383tr_awleys
trawls94412393tr_awl_s
treachery1744693treachery
treaded95014283trea_ded
treader84113833trea_der
treaders93311843treaders
treads74817923trea__ds
treasons848683treasons
treasures946633treasures
treated83618703trea_ted
treater74219833trea_ter
treaters83615853treaters
treatise8311103treatise
treatises9310373treatises
treats64821693trea__ts
treble8311663tre_ble_
trebled1038483tre_bled
treddle936433treddle_
treddled1134473treddled
treeless839283tre_eless
trees55835763tre___es
trehalas1144883trehalas
trellis739873tre_llis
tremble1138003tremble_
trembled1335253trembled
trembler1235363trembler
tremblers1334483tremblers
tremolos1046043tremolos
trenails869843trenail_s
trenched14289853trenched
trencher13279313trencher
trenchers14288073trenchers
trendies9312213trendies
tressels8367653tressels
tresses73719543tre_sses
trestle72611363trestle_
trevallies1343463trevallies
trevallys1542213trevallys
triable92515393triable_
triacids1146723triacids
triacs83913223triac__s
triages82613793tria_ges
trials64319883tria_l_s
triangles1035753triangles
triazoles1844393triazoles
trices84826333tr_ic_es
trickles143013763trickles
tricycles1644363tricycles
trifles103814833tr_ifles
trindles93211693trindles
triples94616873tr_iples
trisceles1145293trisceles
troches123715343tr_oches
troubles1057203troubles
truancies1146883truancies
truces84916333tr_uc_es
truckles14319383truckles
truffles1485593truffles
trundles9278483trundles
tubercles1344163tubercles
tunicles10217133tunicles
tweedles1234113tweedles
upreaches1654633upreaches
ureases74416723urea_ses
utricles1037223utr_icles
vernacles1445073vernacles
wreathes14299893wreathes
wrenches163210233wrenches
wrestles113310063wrestles
wretches16257283wretches

Search took 10 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.423422437.4
2DLD Change Limit1461622609.20315882.0
3Display Results2602600.1102363.6
 (SQL Overall)1786912609.73618353.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.