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

267 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
prattles1018940(None) 
brattles10199331brattles
prattle9208831prattle_
prattled11246531prattled
prattler10166341prattler
prattlers11195321prattlers
rattles73217301_rattles
sprattles1174881sprattles
battles94517682_battles
brattle9249252brattle_
brattled11196722brattled
brittles10178652brittles
patties93425142p_atties
pettles93916482p_ettles
pottles93816982p_ottles
prates84633162pra_t_es
pretties10615132pretties
protyles13249832protyles
rattle64717612_rattle_
rattled84012952_rattled
rattler74012742_rattler
rattlers83510292_rattlers
sprattle1054762sprattle_
sprattled1263312sprattled
tattles73616282_tattles
twattles1154382twattles
wattles103814072_wattles
wrastles11328932wrastles
arables91814973ara_bles
battle85217863_battle_
battled104213123_battled
battler94113383_battler
battlers104110973_battlers
battues94610193_battues
bottles94216273_bottles
brabbles11349753brabbles
bractless1335543bractless
bractlet1239283bractlet
bractlets1344753bractlets
brailles1039493brailles
brambles14308973brambles
brattices1345553brattices
brattier1047663brattier
brattiest1148103brattiest
bristles101510433bristles
brittle9168603brittle_
brittled11186093brittled
brittler10165983brittler
brittlest11146193brittlest
cantles94721413_cantles
castles94917733_castles
catties94023053_catties
cattle85118903_cattle_
chattels13286793chattels
crackles164111273crackles
cradles103114133cra_dles
crankles143510153crankles
cratches153012543cratches
crates85736063cra_t_es
cuittles1045903cuittles
cuttles93613923_cuttles
dartles84014133_dartles
dottles83912283_dottles
drabbles13308523drabbles
draftees12225253draftees
draggles1145963draggles
dratted9358593dratt_ed
embattles1342973embattles
fatties103018203_fatties
fettles103912733_fettles
frazzles19284813frazzles
grabbles13339893grabbles
graciles112511613graciles
grackles15309183grackles
grantees92510973grantees
granules939933granules
grapples13348123grapples
grateless10277583grateless
grates75429893gra_t_es
gristles9189203gristles
grottoes9276753grottoes
gruntles9287233gruntles
guttles83011933_guttles
hantles104117513_hantles
kettles113411613_kettles
kittles113012493_kittles
lattes65324203_latt_es
littles73212783_littles
mantles94820703_mantles
mattes85624533_matt_es
mettles94115023_mettles
mottles93415803_mottles
nettles73214083_nettles
oracles93212423ora_cles
orates64328613ora_t_es
paddles113515643p_addles
padles95221123p_a_dles
pales75753803p_a__les
panties94230933p_anties
pantiles103617153pantiles
papules112411573p_apules
parables121613563parables
parataxes1846393parataxes
parities10522973parities
parles86334403p_a_rles
paroles95025883p_aroles
partakes1449923partakes
particles1339803particles
parties93230863p_arties
partlet92720363p_artlet
partlets102811513p_artlets
pastels95215183p_astels
pastes85233913p_ast_es
pasties94529813p_asties
pastless102411203p_astless
patches143320383p_atches
pates76047893p_a_t_es
pathless13138043p_athless
patines95225763p_atines
patsies93919483p_atsies
patted94724683p_att_ed
pattee84323383p_att_ee
patten84418193p_att_en
pattens95414923p_attens
patter84628263p_att_er
patters94825193p_atters
pattie84020963p_attie_
pestles93217693p_estles
pettle84116053p_ettle_
pettled103611513p_ettled
phatter123810203phatt_er
phattest1336923phatt_est
phratries1447583phratries
piastres10249303piastres
pintles94118723p_intles
pirates93020333pira_t_es
pistoles102514723pistoles
plantlet10310013plantlet
plantlets1145013plantlets
platanes102711883platanes
platelet10510733platelet
platelets1165763platelets
plates85432243pla_t_es
platies93722543pla_ties
platted103614263platt_ed
platter93917413platt_er
platters103415283platters
plotties103111413plotties
portables1337873portables
potables12179703potables
potatoes1039943potatoes
potties93723543p_otties
pottle84416103p_ottle_
practices1557993practices
practise12310143practise
practises1349623practises
praetors1039833praetors
prairies10411453prairies
praises94121103pra_ises
pralines102217723pralines
prances113618773pra_nces
prases84429023pra__ses
prate75135983pra_t_e_
prated94924923pra_t_ed
prater84825353pra_t_er
praters94921653pra_ters
pratfalls1443863pratfalls
pratiques20114213pratiques
prats76333393pra_t__s
prattling1246303prattling
praxes156215183pra__xes
praxises1739063praxises
preambles1545333preambles
preattunes1243973preattunes
prebattle1343013prebattle_
prefiles133113443prefiles
presales10315263presales
presettles1245023presettles
pretapes122811533pretapes
pretells1047333pretells
prettied1159253prettied
prettier1069043prettier
prettiest1199803prettiest
pretypes15337263pretypes
pretzels1934033pretzels
prickles162511093prickles
printless1137513printless
proettes10312763proettes
profiles133211233profiles
proles84627203pr__oles
prosties101421193prosties
prostyles14157113prostyles
protases102115033protases
proteges1149923proteges
protyle12229453protyle_
protyls12298463protyl_s
pustules1038443pustules
puttees93612913p_uttees
putties94420023p_utties
rabbles113517973_rabbles
raddles93615703_raddles
raffles133611843_raffles
raggles93813283_raggles
rales54947493_ra__les
rambles113118313_rambles
rankles113114543_rankles
rassles73513923_rassles
ratables10159723_ratables
ratals64219583_ratal_s
ratches123620463_ratches
ratels64518213_ratel_s
rates55352013_ra_t_es
ratholes11312413_ratholes
ratines75328583_ratines
ratites74920683_ratites
rattans73411953_rattans
ratted74923343_ratt_ed
ratteen7329113_ratteen
ratteens8256053_ratteens
ratten64217383_ratt_en
rattens74213403_rattens
ratter64326313_ratt_er
ratters74422473_ratters
rattier74015593_rattier
rattiest83516113_rattiest
rattly94111543_rattl_y
rattons73815323_rattons
retiles74426993_retiles
retitles83612593_retitles
rootles73215633_rootles
rottes64524833_rott_es
rustles73416413_rustles
rutiles74315843_rutiles
scuttles1056503scuttles
settles73916003_settles
shuttles1136553shuttles
skatoles1236143skatoles
skittles1245763skittles
spatzles1935303spatzles
spittles1038333spittles
spraddles13194283spraddles
startles82111963startles
tatties74120343_tatties
tattle64115653_tattle_
tattled84311483_tattled
tattler73112213_tattler
tattlers8369693_tattlers
throttles1254353throttles
tittles73413253_tittles
trachles13311753trachles
tramples122610203tramples
trestles83012553trestles
twattle1064273twattle_
twattled1273463twattled
uprates93814863upra_t_es
urates65027763ura_t_es
vittles103211113_vittles
warstles11368803warstles
wattle94314213_wattle_
wattled113610503_wattled
wattless11268723_wattless
whittles1496673whittles
wrangles1237463wrangles
wrassles11376713wrassles
wrastle10368993wrastle_
wrastled12346433wrastled
wrestles113310063wrestles

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.406440125.6
2DLD Change Limit1461622677.37319824.0
3Display Results2672670.1102427.3
 (SQL Overall)1786912677.88922650.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.