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

238 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
prattled1124653(None) 
brattled11196721brattled
prattle9208831prattle_
prattler10166341prattler
prattles10189411prattles
rattled84012951_rattled
sprattled1263311sprattled
battled104213122_battled
brattle9249252brattle_
brattles10199332brattles
brittled11186092brittled
dratted9358592dratt_ed
patted94724682p_att_ed
pettled103611512p_ettled
platted103614262platt_ed
prated94924922pra_t_ed
prattlers11195332prattlers
prettied1159252prettied
ratted74923342_ratt_ed
rattle64717612_rattle_
rattler74012742_rattler
rattles73217302_rattles
sprattle1054762sprattle_
sprattles1174882sprattles
tattled84311482_tattled
twattled1273462twattled
wattled113610502_wattled
wrastled12346432wrastled
batted95623653_batt_ed
battle85217863_battle_
battler94113383_battler
battles94517683_battles
blatted104812713blatt_ed
bottled104611233_bottled
brabbled12337633brabbled
bracted12410933bract_ed
bractlet1239283bractlet
brailed103914013bra_iled
brailled1147193brailled
brambled15316733brambled
bratticed1443283bratticed
brattier1047663brattier
brawled133910123bra_wled
bristled11187343bristled
brittle9168603brittle_
brittler10165983brittler
brittles10178653brittles
castled104311513_castled
catted95422473_catt_ed
cattle85118903_cattle_
chatted133411893chatt_ed
craaled10339423cra_aled
crackled17428863crackled
cradled113410813cra_dled
crafted13419773craft_ed
crankled15408153crankled
crated94827773cra_t_ed
cratered1149693cratered
crawled133710403cra_wled
cuittled1133993cuittled
cuttled10319933_cuttled
dartled9409853_dartled
deratted1048403deratt_ed
drabbled14367053drabbled
drafted12439033draft_ed
draggled1254673draggled
drawled12368343dra_wled
embattled1442563embattled
fatted105419843_fatt_ed
fettled11378933_fettled
flatted114012943flatt_ed
fracted1339373fract_ed
frazzled20303993frazzled
fretted113411853frett_ed
fritted113611333fritt_ed
grabbled14327373grabbled
grafted124110223graft_ed
granted94715103grant_ed
grappled14336093grappled
grated84523923gra_t_ed
graveled13417363graveled
gritted94110903gritt_ed
grottoed10234503grottoed
gruntled10274943gruntled
guttled9378993_guttled
hatted104921513_hatt_ed
kittled12388193_kittled
kraaled12254983kra_aled
mantled104113393_mantled
matted94521413_matt_ed
mettled103510543_mettled
mottled10409973_mottled
nettled8339943_nettled
orated74221503ora_t_ed
paddled123612023p_addled
paled85538723p_a__led
palled94625163p_a_lled
paneled10612573p_aneled
panted95024823p_ant_ed
pantiled113111593pantiled
parasoled1246363parasoled
parceled1338343parceled
parled94626293p_a_rled
paroled104217633p_aroled
parted94228683p_art_ed
partied103516553p_artied
partlet92720363p_artlet
pasted94426903p_ast_ed
patched153514623p_atched
pated85237843p_a_t_ed
patined105114783p_atined
pattee84323383p_att_ee
patten84418193p_att_en
pattened11299393p_attened
patter84628263p_att_er
pattered112714213p_attered
pattie84020963p_attie_
patties93425143p_atties
pealed95322813pea__led
pearled10411553pea_rled
pestled102711453p_estled
petaled103614153p_etaled
petalled1138713petalled
petted94121523p_ett_ed
pettle84116053p_ettle_
pettles93916483p_ettles
phatter123810203phatt_er
pirated102515613pira_t_ed
pistoled11259593pistoled
pitted94319593p_itt_ed
plaited103713893plait_ed
planted103516123plant_ed
plantlet10310013plantlet
plated95225773pla_t_ed
platelet10510733platelet
platter93917413platt_er
plotted104612373plott_ed
portaled11239203portaled
potted94624013p_ott_ed
pottle84416103p_ottle_
pottles93816983p_ottles
practiced1655113practiced
practised1446103practised
praised104214813pra_ised
pranced123714043pra_nced
pranged114512553pra_nged
pranked143712093pra_nked
prate75135983pra_t_e_
prater84825353pra_t_er
prates84633163pra_t_es
prattling1246303prattling
prawned1346743pra_wned
prayed124815433pra__yed
preacted132710943preact_ed
preambled1643893preambled
preattuned1342813preattuned
prebattle1343013prebattle_
prefiled143310573prefiled
presettled1344083presettled
pretaped13339133pretaped
pretold1049083pretol_d
prettier1069043prettier
pretties10615133pretties
pretyped16306123pretyped
prickled17358073prickled
prilled104713003pr_illed
printed104016373print_ed
profiled14338523profiled
protyle12229453protyle_
protyles13249833protyles
prowled13309913pr_owled
pustuled1134953pustuled
putted94220253p_utt_ed
puttied103811163p_uttied
rabbled123514423_rabbled
raddled103812223_raddled
raffled14429083_raffled
rafted104714703_raft_ed
railed74727543_ra_iled
rambled123913523_rambled
rankled123910653_rankled
ranted74324703_rant_ed
rassled83310453_rassled
rated65441383_ra_t_ed
rattailed1084213_rattailed
ratteen7329113_ratteen
ratten64217383_ratt_en
rattened9218623_rattened
ratter64326313_ratt_er
rattier74015593_rattier
rattlers83510293_rattlers
rattly94111543_rattl_y
raveled114113633_raveled
retiled84420513_retiled
retitled9339553_retitled
retted74826313_rett_ed
rootled83410533_rootled
rotted74524433_rott_ed
rustled83311323_rustled
rutted74518403_rutt_ed
scatted103512773scatt_ed
scuttled1134533scuttled
settled83210873_settled
shuttled1234673shuttled
slatted84015183slatt_ed
spatted104014143spatt_ed
splatted11356743splatt_ed
spraddled14203463spraddled
sprawled1434523spra_wled
startled9208563startled
swatted114110693swatt_ed
tatted74920533_tatt_ed
tattle64115653_tattle_
tattler73112213_tattler
tattles73616283_tattles
throttled1352963throttled
trachled1438313trachled
trailed83415673tra_iled
trameled11309073trameled
trampled13247903trampled
traveled12349453traveled
trawled113411523tra_wled
trotted83711283trott_ed
twattle1064273twattle_
twattles1154383twattles
uprated103213323upra_t_ed
vatted104214733_vatt_ed
vittled11347343_vittled
warstled12286123warstled
wattle94314213_wattle_
wattles103814073_wattles
whittled1594913whittled
wrangled1335593wrangled
wrassled12325383wrassled
wrastle10368993wrastle_
wrastles11328933wrastles
wrathed14298523wra_thed
wrestled12296763wrestled

Search took 9 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.436409841.7
2DLD Change Limit1461622387.54619369.5
3Display Results2382380.0932559.1
 (SQL Overall)1786912388.07522128.9
 
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.