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

216 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
prattler1016634(None) 
prattle9208831prattle_
prattled11246531prattled
prattlers11195321prattlers
prattles10189401prattles
rattler74012741_rattler
battler94113382_battler
brattier1047662brattier
brattle9249252brattle_
brattled11196722brattled
brattles10199332brattles
brittler10165982brittler
patter84628262p_att_er
phatter123810202phatt_er
platter93917412platt_er
prater84825352pra_t_er
prettier1069042prettier
ratter64326312_ratt_er
rattier74015592_rattier
rattle64717612_rattle_
rattled84012952_rattled
rattlers83510292_rattlers
rattles73217302_rattles
sprattle1054762sprattle_
sprattled1263312sprattled
sprattles1174882sprattles
tattler73112212_tattler
antler64615553__antler
batter84928873_batt_er
battier93515713_battier
battle85217863_battle_
battled104213123_battled
battlers104110973_battlers
battles94517683_battles
blatter94415653blatt_er
bottler94211883_bottler
brabbler11397373brabbler
bractlet1239283bractlet
brailler1036883brailler
brawler124310233bra_wler
brittle9168603brittle_
brittled11186093brittled
brittles10178653brittles
cattier93317073_cattier
cattle85118903_cattle_
chatter124416643chatt_er
chattier1337513chattier
clatter94014973clatt_er
cradler102910513cra_dler
crafter124111333craft_er
craftier1376193craftier
crater85026643cra_t_er
crawler123510463cra_wler
critter94113033critt_er
drafter11449423draft_er
draftier1285263draftier
dratted9358593dratt_ed
drawler11338593dra_wler
fatter94523213_fatt_er
fattier103513463_fattier
flatter103815963flatt_er
frailer10319943fra_iler
frater94520593fra_t_er
fretter103412753frett_er
frettier1156593frettier
fritter103912773fritt_er
gnattier934263gnattier
grabbler13377693grabbler
grafter114211153graft_er
granter84117133grant_er
grappler13336193grappler
grater74625443gra_t_er
gritter83913353gritt_er
grittier9316263grittier
grottier9316673grottier
guttler8369163_guttler
hatter94724873_hatt_er
irater65218353ira_t_er
kittler11338163_kittler
krater104014313kra_t_er
latter65027893_latt_er
littler7348553_littler
matter84325343_matt_er
mottler94410343_mottler
natter64420743_natt_er
nattier73614623_nattier
nettler7349503_nettler
paddler113711553p_addler
paler75436933p_a__ler
palter84423263p_alt_er
panther12611443p_anther
partaker1436873partaker
partier93520713p_artier
partlet92720363p_artlet
partner92811393p_artner
partyer12337873p_artyer
paster85734373p_ast_er
pastier94320383p_astier
patcher143515143p_atcher
pater74740723p_a_t_er
patted94724683p_att_ed
pattee84323383p_att_ee
patten84418193p_att_en
patterer103112173p_atterer
pattern93712053p_att_ern
patters94825193p_att_ers
pattie84020963p_attie_
patties93425143p_atties
patzer173111643p_a_tzer
pearler9310373pea_rler
pearter9412743peart_er
peatier94017233pea_tier
petter83924773p_ett_er
pettier94213613p_ettier
pettle84116053p_ettle_
pettled103611513p_ettled
pettles93916483p_ettles
piaster93012883piast_er
plaiter93615393plait_er
planter94017803plant_er
plantlet10310013plantlet
plaster93318693plast_er
platelet10510733platelet
plater84427693pla_t_er
platier93716293pla_tier
platted103614263platt_ed
platters103415283platt_ers
plotter94113663plott_er
plottier10327263plottier
potter83926983p_ott_er
pottier93516493p_ottier
pottle84416103p_ottle_
pottles93816983p_ottles
practicer1544593practicer
praetor938973praet_or
praiser93413943pra_iser
prancer113613383pra_ncer
prate75135983pra_t_e_
prated94924923pra_t_ed
praters94921653pra_t_ers
prates84633163pra_t_es
prattling1246303prattling
prawner1246803pra_wner
prayer114815293pra__yer
prealter1048863prealt_er
prebattle1343013prebattle_
prester93519623prest_er
prettied1159253prettied
pretties10615133pretties
printer93917303print_er
profiler13287643profiler
protyle12229453protyle_
protyles13249833protyles
prowler123310013pr_owler
psalter9247813psalt_er
putter83921443p_utt_er
puttier93314503p_uttier
rabbler113514093_rabbler
raffler13339223_raffler
rafter94517583_raft_er
railer64524933_ra_iler
rambler113313263_rambler
ranter63826823_rant_er
raster64731443_rast_er
rater54943283_ra_t_er
rather94319743_ra_ther
ratted74923343_ratt_ed
ratteen7329113_ratteen
ratten64217383_ratt_en
rattener8238533_rattener
ratters74422473_ratt_ers
rattly94111543_rattl_y
raveler104212463_raveler
ritter63822423_ritt_er
rotter64325463_rott_er
rustler73512343_rustler
ruttier73412283_ruttier
scatter93815173scatt_er
scattier10267583scattier
settler73410653_settler
shatter103615703shatt_er
shuttler1164903shuttler
smatter93613333smatt_er
spatter94016523spatt_er
splatter10348883splatt_er
sprawler1334653spra_wler
startler8248793startler
swatter104113323swatt_er
tatter64024573_tatt_er
tattier74216243_tattier
tattle64115653_tattle_
tattled84311483_tattled
tattlers8369693_tattlers
tattles73616283_tattles
throttler1262863throttler
trailer73015393tra_iler
trampler12278013trampler
traveler11328433traveler
trawler104011903tra_wler
trotter73312253trott_er
twattle1064273twattle_
twattled1273463twattled
twattles1154383twattles
warstler11275933warstler
watter93221983_watt_er
wattle94314213_wattle_
wattled113610503_wattled
wattles103814073_wattles
whittler1495193whittler
wrangler1245473wrangler
wrastle10368993wrastle_
wrastled12346433wrastled
wrastles11328933wrastles
wrathier1435903wrathier
wrestler11306993wrestler
yatter94116213_yatt_er

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 Limit1461622166.59322169.3
3Display Results2162160.0802700.0
 (SQL Overall)1786912167.07925242.4
 
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.