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

254 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
prattle920883(None) 
brattle9249251brattle
prattled11246531prattled
prattler10166341prattler
prattles10189401prattles
rattle64717611_rattle
sprattle1054761sprattle
battle85217862_battle
brattled11196722brattled
brattles10199332brattles
brittle9168602brittle
cattle85118902_cattle
pattee84323382p_attee
pattie84020962p_attie
pettle84116052p_ettle
pottle84416102p_ottle
prate75135982pra_t_e
prattlers11195322prattlers
prebattle1343012prebattle
protyle12229452protyle
rattled84012952_rattled
rattler74012742_rattler
rattles73217302_rattles
rattly94111542_rattly
sprattled1263302sprattled
sprattles1174882sprattles
tattle64115652_tattle
twattle1064272twattle
wattle94314212_wattle
wrastle10368992wrastle
arable81821003ara_ble
battled104213123_battled
battler94113383_battler
battles94517683_battles
battue84311003_battue
bottle84916073_bottle
brabble10349973brabble
bractlet1239283bractlet
braille939713braille
bramble133710033bramble
brattice1245693brattice
brattier1047663brattier
bratty1159683bratt_y
bristle91910103bristle
brittled11186093brittled
brittler10165983brittler
brittles10178653brittles
brittly12165973brittly
cantle84522153_cantle
castle84918963_castle
cattie85221013_cattie
chattel12388893chattel
crackle153611253crackle
cradle93313163cra_dle
crankle133610063crankle
crate76537403cra_t_e
cuittle946403cuittle
cuttle84113893_cuttle
dartle73714833_dartle
dottle74212503_dottle
drabble12238883drabble
draftee11379523draftee
draggle1056103draggle
dratted9358593dratted
embattle1253273embattle
fettle93713123_fettle
fragile1147843fragile
frazzle18305223frazzle
grabble12339643grabble
gracile102512603gracile
grackle14338893grackle
grantee83217133grantee
granule839473granule
grapple12378003grapple
grate64932883gra_t_e
gratine84719193gratine
gristle8169223gristle
gruntle8257053gruntle
guttle74111973_guttle
hantle94318203_hantle
irate55627983ira_t_e
irately1047683irately
kettle104311613_kettle
kittle104012173_kittle
latte55426303_latt_e
little63312163_little
mantle84420923_mantle
matte75626843_matt_e
mettle83815723_mettle
mottle84116053_mottle
nettle64514583_nettle
oracle84313293ora_cle
orate55133303ora_t_e
paddle104615143p_addle
padle84522343p_a_dle
pale66055013p_a__le
pantie84326473p_antie
pantile93918483pantile
papule102212133p_apule
parable111819773parable
parle75836163p_a_rle
parole84425253p_arole
partake1339643partake
partible1238063partible
particle1239533particle
partite9317133partite
partlet92720363p_artlet
partly116315473p_artly
paste74932953p_ast_e
pastel85918713p_astel
pastie85525523p_astie
pate65350463p_a_t_e
patine85328123p_atine
patly105020583p_a_tly
patted94724683p_atted
patten84418193p_atten
patter84628263p_atter
patties93425143p_atties
patty104723613p_att_y
peartly1267453peartly
pestle83215843p_estle
pettled103611503p_ettled
pettles93916483p_ettles
phatter123810203phatter
piastre9307893piastre
pintle83818263p_intle
pirate82322883pira_t_e
pistole92414313pistole
plantlet10310013plantlet
platane93112303platane
plate74635113pla_t_e
platelet10510733platelet
platted103614263platted
platter93917413platter
portable12313203portable
potable112115363potable
pottles93816983p_ottles
practic13312243practic
practice1438733practice
practise12310143practise
praetor938973praetor
prairie938333prairie
praise84419413pra_ise
praline93019743praline
prance104318573pra_nce
prase76128753pra__se
prat65952043pra_t__
prated94924923pra_ted
prater84825353pra_ter
praters94921643praters
prates84633163pra_tes
pratfall1344153pratfall
prating103424453prating
pratique19134283pratique
prats76333393pra_t_s
prattling1246303prattling
preamble1436373preamble
preattune1143573preattune
prefile123413183prefile
presale9416353presale
presettle1145933presettle
pretape113511623pretape
pretell938233pretell
pretold1049083pretold
prettied1159253prettied
prettier1069043prettier
pretties10615133pretties
prettily1337273prettily
pretty11510873prett_y
pretype14387483pretype
pretzel1835143pretzel
prickle153611013prickle
prithee1239933prithee
proette9312363proette
profile123211153profile
prole74527793pr__ole
prostie91617743prostie
prostyle13187273prostyle
protege1059153protege
protyl11308213protyl_
protyles13249833protyles
protyls12298463protyls
prythee1545383prythee
pustule937683pustule
puttee85919723p_uttee
puttie84116303p_uttie
rabble103818243_rabble
rackle123917293_rackle
raddle84816173_raddle
raffle123910703_raffle
raggle83712883_raggle
rale45050563_ra__le
ramble104519973_ramble
rankle103414883_rankle
raptly11338913_raptly
rassle63813203_rassle
ratable91717553_ratable
ratal55025113_ratal_
ratals64219583_ratals
rate45458763_ra_t_e
ratel54224883_ratel_
ratels64518213_ratels
rathe85821923_ra_the
rathole10312053_rathole
ratine65131823_ratine
ratite65022423_ratite
rattan63613603_rattan
ratted74923343_ratted
ratteen7329113_ratteen
ratten64217383_ratten
ratter64326313_ratter
rattier74015593_rattier
rattlers83510293_rattlers
ratton64116123_ratton
ratty84819593_ratt_y
retile65929673_retile
retitle73913093_retitle
rootle63214453_rootle
rotte54625933_rott_e
rustle63615413_rustle
rutile65217683_rutile
scuttle936463scuttle
settle63915663_settle
shuttle1046093shuttle
skatole1135683skatole
skittle1135523skittle
spatzle1834573spatzle
spittle937923spittle
spraddle12194163spraddle
startle72511123startle
tattie64817513_tattie
tattled84311483_tattled
tattler73112213_tattler
tattles73616283_tattles
throttle1164073throttle
tittle63613323_tittle
trachle12311853trachle
tractile10311073tractile
trample11299703trample
trestle72611363trestle
twattled1273463twattled
twattles1154383twattles
uprate83916543upra_t_e
urate55432163ura_t_e
vittle94711753_vittle
warstle10328013warstle
wattled113610503_wattled
wattles103814073_wattles
whittle13106103whittle
wrangle1137383wrangle
wrassle10357173wrassle
wrastled12346433wrastled
wrastles11328933wrastles
wrestle10298843wrestle

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340272548.11016526.1
3Display Results2542540.0763342.1
 (SQL Overall)1786912548.32621461.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.