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

296 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
trestle7261136(None) 
trestles83012551trestles
wrestle10298841wrestle
bristle91910102bristle
gristle8169222gristle
nestle63013952_nestle
pestle83215842_pestle
presale9416352presale
resale64025542_resale
resile64627672_resile
resole64624182_resole
restyle1038762_restyle
rustle63615412_rustle
testae64216252t_estae
testee64323302t_estee
thistle10107802thistle
throstle1175702throstle
treacle939972treacle
treadle8310102treadle
treble8311662tre_ble
treddle936432treddle
tremble1138002tremble
tressel73010892tressel
triste63818642trist_e
trustee73514442trustee
tryste9399582tryst_e
wrastle10368992wrastle
wrestled12296762wrestled
wrestler11306992wrestler
wrestles113310062wrestles
apostle937853apostle
areole61017283are_ole
arete56031353are_t_e
aristae7312533aristae
arrestee849443arrestee
atremble1244113atremble
beetle8311673_beetle
brattle9249253brattle
breathe123711843breathe
bristled11187343bristled
bristles101510433bristles
bristly12178063bristly
brittle9168603brittle
bustle84015483_bustle
castle84918963_castle
create85126383creat_e
creole8913733cre_ole
cresol8310213cresol_
cresols939653cresols
crest74632693crest__
crestal9312133crestal
crested103416533crested
crestless1146783crestless
crests85218703crest_s
cresyl1135133cresyl_
cresyls1234753cresyls
cristae9310613cristae
drest65530343drest__
epistle957893epistle
erectile1039513erectile
erectly1257483erectly
fettle93713123_fettle
freckle16106643freckle
freestyle1542603freestyle
freshly16286833freshly
fresnel1035893fresnel
frustule1154483frustule
gentle74014513_gentle
geste65920693_gest_e
greatly1137613greatly
gristles9189203gristles
gristly11187333gristly
gruntle8257053gruntle
hustle93113993_hustle
istle52214713__istle
jostle13319863_jostle
justle133211583_justle
kettle104311613_kettle
mestee84523883_mestee
mettle83815723_mettle
nestled8349903_nestled
nestler73510443_nestler
nestles73015463_nestles
nettle64514583_nettle
outwrestle13101953outwrestle
pestled102711443_pestled
pestles93217693_pestles
pettle84116053_pettle
prattle9208833prattle
prefile123413183prefile
presage10312293presage
presales10315263presales
prese75228383pres__e
presell939303presell
presettle1145943presettle
preside10715613preside
presold1059603presold
presolve1347073presolve
prest75736353prest__
prester93519623prester
prestige11310733prestige
presto84216203prest_o
prestore104217353prestore
prestos93716083prestos
prests84021263prest_s
presume11310303presume
priestly1345843priestly
prostie91617743prostie
prostyle13187273prostyle
rassle63813203_rassle
rattle64717613_rattle
reddle83815913_reddle
refile95122373_refile
regale74821453_regale
rente54733783_rent_e
reptile93914083_reptile
resales74724903_resales
rescale93215473_rescale
rescue8313003_rescue
resee54336333_res_ee
resell64215203_resell
resettle837303_resettle
reshoe92816483_reshoe
reside74224933_reside
resiled84621983_resiled
resiles74026543_resiles
resite64128453_resite
resize154117723_resize
resold73915363_resold
resoled84119283_resoled
resoles73823653_resoles
resolve103910983_resolve
rest46459843_rest__
restable101618443_restable
restage83316193_restage
restate73824883_restate
rested74430783_rested
rester63832433_rester
restive10315933_restive
restless82713163_restless
restoke116113903_restoke
restore75822983_restore
rests54935873_rest_s
restyled1236943_restyled
restyles1139193_restyles
result6318223_result
resume8313783_resume
rete44944133_re_t_e
retie55735303_re_tie
retile65929673_retile
retitle73913093_retitle
revile94921613_revile
rootle63214453_rootle
rustled83311323_rustled
rustler73512343_rustler
rustles73416413_rustles
settle63915663_settle
strette7310763stre_tte
taste55127233t_ast_e
tattle64115653t_attle
teazle15329553t_eazle
teethe94511313t_eethe
tele45040873t_e__le
temple102811333t_emple
tensile72612733tensile
tentie62521183t_entie
terete6319333teret_e
terse55026823ters__e
tersely1038113tersely
tesla55612603t_es_la
test48651623t_est__
testa54822043t_est_a
testable101412623t_estable
testate73916233t_estate
tested74421523t_ested
testees74215913t_estees
tester64227153t_ester
testes65125823t_estes
testicle1037443t_esticle
testier74015643t_estier
testily102910803t_estily
testis64916713t_estis
teston6313303t_eston
tests56530193t_est_s
testy85419063t_est_y
textile1437223t_extile
theatre10358493theatre
these86519013thes__e
thistles1198233thistles
thistly1395963thistly
throstles1265903throstles
throttle1164083throttle
tiresome1046993tiresome
title54721073t__itle
tittle63613323t_ittle
toeshoe1047843toeshoe
tootle62613813t_ootle
tousle64514653tous_le
trachle12311853trachle
tractile10311073tractile
trample11299703trample
treacles1039703treacles
treacly1237093treacly
treadled1067123treadled
treadler936863treadler
treadles939703treadles
treasure846753treasure
treat56240353treat__
treatable1139323treatable
treated83618703treated
treater74219833treater
treaties8316983treaties
treatise8311103treatise
treats64821693treat_s
treaty94414353treat_y
trebled1038483tre_bled
trebles9311443tre_bles
trebly1138973tre_bly
treddled1134473treddled
treddles1036263treddles
tree47745813tre___e
treetop945523treetop
trehala1045953trehala
trembled1335253trembled
trembler1235363trembler
trembles1237353trembles
trembly1435523trembly
tremolo946513tremolo
tres46542903tres___
tress55423163tres__s
tressed83714263tressed
tressels8367653tressels
tresses73719543tresses
tressier847963tressier
tressure846483tressure
tressy9448553tres_sy
tret46653533tre_t__
trets55928023tre_t_s
triable92515393triable
trickle133613443trickle
trifle94012883tr_ifle
trindle83311363trindle
triple84215923tr_iple
triscele1045433triscele
triseme936543triseme
triskele1244573triskele
trisome9310223trisome
tristate8311033tristate
trite54730033tr_it_e
trouble957713trouble
truckle13358863truckle
truest64816193truest__
truffle1384893truffle
trundle8307873trundle
trust55426853trust__
trustable1147123trustable
trusted83412793trusted
trusteed9346533trusteed
trustees8339323trustees
truster73114313truster
trustier8268683trustier
trusties82712853trusties
trustily11257103trustily
trustless955953trustless
trustor7238413trustor
trusts64714433trust_s
trusty94710113trust_y
tryst84716223tryst__
trysted11428273trysted
tryster10369513tryster
trystes10419993trystes
trysts9448793tryst_s
tsetse664693tse_tse
turnsole844693turnsole
turnstile943173turnstile
turtle63213573t_urtle
tussle637143t_ussle
twattle1064273twattle
tweedle1134193tweedle
typestyle1751823typestyle
tzetze1432733tze_tze
urostyle11173953urostyle
verste94515633verst_e
vestee94319153_vestee
warstle10328013warstle
whistle13107533whistle
wrassle10357173wrassle
wrastled12346433wrastled
wrastles11328933wrastles
wreathe13339053wreathe
wrest84925433wrest__
wrested113410933wrested
wrester102812413wrester
wrestlers12306103wrestlers
wrests95313083wrest_s
wristlet1138643wristlet

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.436409841.7
2DLD Change Limit1340272967.21618573.6
3Display Results2962960.1102690.9
 (SQL Overall)1786912967.76223021.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.