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

298 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
prettier106904(None) 
frettier1156591frettier
pettier94213611p_ettier
prettied1159251prettied
pretties10615131pretties
brattier1047662brattier
fretter103412752frett_er
grittier9316262grittier
grottier9316672grottier
jettier14358692_jettier
nettier74211812_nettier
peatier94017232p_eatier
pestier94317402p_estier
petter83924772p_ett_er
plottier10327262plottier
pottier93516492p_ottier
prattler10166342prattler
premier113515632pre_mier
preppier1156642preppier
prester93519622prest_er
prettiest1199802prettiest
prettifier1543972prettifier
prettify1644342prettify
prettily1337282prettily
puttier93314502p_uttier
rattier74015592_rattier
rentier73618222_rentier
ruttier73412282_ruttier
abetter958323abett_er
artier63419733ar__tier
artsier768943ar_tsier
battier93515723_battier
better84723703_bett_er
bittier94211663_bittier
blottier10336413blottier
breather133610593breather
breathier1435383breathier
breezier1934533breezier
brevier1237763bre_vier
brittler10165983brittler
cattier93317073_cattier
chattier1337513chattier
chertier1387873chertier
chestier1387423chestier
cottier93814173_cottier
craftier1376193craftier
creakier14328333creakier
creamier12319063creamier
creasier103210203creasier
creepier1236253creepier
crepier1139753cre_pier
critter94113033critt_er
crustier10259533crustier
dottier83910923_dottier
draftier1285263draftier
dreamier11287293dreamier
drearier9297923drearier
dreggier1193553dreggier
dressier956863dressier
driftier1275123driftier
erecter93113393erect_er
fattier103513463_fattier
fetter94120383_fett_er
freakier15246483freakier
fretted113411853frett_ed
fretters113410303frett_ers
frettiest1267073frettiest
fretting122711523fretting
fritter103912773fritt_er
frontier1147313frontier
frostier1148163frostier
frothier1435953frothier
fruitier1136593fruitier
getter74117613_gett_er
gleetier934913gleetier
gnattier934263gnattier
greasier9298083greasier
greater84416493great_er
greedier1036083greedier
greenier938713greenier
greeter82812673greet_er
gritter83913353gritt_er
groutier9297173groutier
guttier83911103_guttier
heftier1337203_heftier
jettied15366973_jettied
jetties143613123_jetties
knottier12203983knottier
kreutzer2141273kreutzer
letter63722583_lett_er
meatier93214613_meatier
metier83517693_me_tier
nattier73614623_nattier
netter63722023_nett_er
nettler7349503_nettler
nettlier864813_nettlier
nittier73512243_nittier
nuttier73112023_nuttier
paintier1048793paintier
paltrier1037543paltrier
partier93520713p_artier
pastier94320383p_astier
patter84628263p_att_er
pattie84020963p_attie_
patties93425143p_atties
peakier134411443p_eakier
peckier153910523p_eckier
pelter83321623p_elt_er
peppier10268323p_eppier
peptizer21236473p_eptizer
perkier133813123p_erkier
perter84422283p_ert_er
peskier13319113p_eskier
pester84827593p_est_er
peter74427593p_e_t_er
petite84320653p_etite_
petites93820203p_etites
petted94121523p_ett_ed
petters93722363p_ett_ers
petti75119453p_etti__
pettiest103113963p_ettiest
pettily1238173p_ettily
petting103720953p_etting
pettish1238283p_ettish
pettle84116053p_ettle_
pettled103611513p_ettled
pettles93916483p_ettles
pewter114013673p_ewt_er
phatter123810203phatt_er
pieties9419223pie_ties
pithier123010293p_ithier
pitier84019823p__itier
platier93716293p_latier
platter93917413platt_er
pleater93916333pleat_er
pleather1356653pleather
plenties10314693plenties
plotter94113663plott_er
plotties103111413plotties
poetiser1037313poetiser
poetizer1936813poetizer
poetries10315583poetries
pointier1038303pointier
portlier1038373portlier
potter83926983p_ott_er
potties93723543p_otties
poutier93215323p_outier
practicer1544593practicer
prater84825353pr_at_er
prattle9208833prattle_
prattled11246533prattled
prattlers11195333prattlers
prattles10189413prattles
preacher153211373preacher
preachier1646923preachier
prealter1048863prealter
preaver121011613pre_aver
preciser123411663preciser
precited133013813precited
predried12309573predried
predries112714383predries
preemie11310563preemie_
preemies12512193preemies
preener93114833pre_ener
prefacer1537983prefacer
prefer113813203pre__fer
prefire124012813pre_fire
preluder1135733preluder
premie103617993pre_mie_
premiere12249233pre_miere
premiers122911653pre_miers
premies113823063pre_mies
prentice121012353prentice
prenticed14118063prenticed
prentices131111903prentices
preorder1136463preorder
preparer12169643preparer
preppie1058093preppie_
preppies1149693preppies
presager1138443presager
presider11410423presider
presser93717623pre_sser
presters103419003prest_ers
prestige11310733prestige
prestiges12310593prestiges
prestore104217353prestore
presumer1247583presumer
pretape113511623pretape_
pretaped13339133pretaped
pretapes122811533pretapes
preteen939873pre_teen
pretender1246663pretender
preterm11310163pre_t_erm
pretor8315753pre_t_or
pretrial10511983pretrial
pretrim11310783pretri_m
pretrims1238983pretrims
prettified1644943prettified
prettifiers1642513prettifiers
prettifies1545693prettifies
prettiness1257393prettiness
pretty11510873prett__y
prettying1536043prettying
prettyish1743053prettyish
pretype14387483pretype_
pretyped16306123pretyped
pretypes15337263pretypes
pretzel1835143pre_tzel
prevailer1445153prevailer
preview1536473pre_view
prewire124311143pre_wire
prexies163415003pre_xies
preyer114413733pre__yer
pricier113313113pr_icier
prickier16368143prickier
prier75027763pr___ier
priestlier1242883priestlier
printer93917303print_er
prissier10157873prissier
privier122910453pr_ivier
proette9312363proett_e_
proettes10312763proett_es
profiter132710203profiter
prosier93817493pr_osier
prostie91617743prostie_
prosties101421193prosties
purtier93214093p_urtier
putter83921443p_utt_er
puttie84116303p_uttie_
puttied103811163p_uttied
puttiers10288013p_uttiers
putties94420023p_utties
ratter64326313_ratt_er
rattler74012743_rattler
readier83117423_readier
reciter94117263_reciter
reedier83815303_reedier
reefier102912553_reefier
reekier113111123_reekier
reifier103414523_reifier
relier65826183_re_lier
renter64527413_rent_er
rentiers83311763_rentiers
replier94214973_replier
rester63832433_rest_er
retailer82911573_retailer
retainer82913813_retainer
retaker113714313_retaker
retie55735303_re_tie_
retied75924983_re_tied
reties65436193_re_ties
retire64927013_re_tire
retirer74715013_retirer
retried84419163_retried
retries74129073_retries
retted74826313_rett_ed
retting83425883_retting
reutter71010093_reutter
ritter63822423_ritt_er
ritzier16297203_ritzier
rootier74915393_rootier
rotter64325463_rott_er
runtier73512853_runtier
rustier74416363_rustier
scattier10267583scattier
setter64023723_sett_er
settler73410653_settler
shittier1137313shittier
sleetier837883sleetier
slittier837003slittier
sluttier836453sluttier
smuttier1035213smuttier
snottier8217383snottier
spottier10207313spottier
sweatier1147033sweatier
tattier74216243_tattier
tentier73815923_tentier
testier74015643_testier
tetter64322453_tett_er
treater74219833treat_er
treaties8316983treaties
trendier937913trendier
tressier847963tressier
trotter73312253trott_er
troutier8277153troutier
trustier8268683trustier
upsetter1034643upsett_er
ureter6313203ure_t_er
vetter93417643_vett_er
wetter93919443_wett_er
whetter13348803whett_er
wittier103910823_wittier
wrathier1435903wrathier
wreather14268603wreather
wrester102812413wrest_er
wrestler11306993wrestler
wristier1136863wristier
zestier163010223_zestier

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.420425454.8
2DLD Change Limit1461622986.65621959.4
3Display Results2982980.1102709.1
 (SQL Overall)1786912987.18624866.5
 
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.