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

120 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
prettily133728(None) 
pettily1238171p_ettily
prettify1644341prettify
grittily1244182grittily
preppily1444592preppily
prettied1159252prettied
prettier1069042prettier
pretties10615132pretties
pretty11510872prett__y
ruttily10338612_ruttily
artily92814713ar__tily
breathily1744063breathily
breezily2243653breezily
brittly12165973britt_ly
cattily123210853_cattily
chattily1634603chattily
chestily1645523chestily
craftily1644783craftily
creakily1735393creakily
creamily1536363creamily
creepily1574953creepily
crustily13328173crustily
dottily1147283_dottily
draftily1534413draftily
dreamily1435143dreamily
drearily1236083drearily
dressily1246443dressily
erectile1039513erectile
erectly1257483erect_ly
fattily13379463_fattily
freakily1835003freakily
frenzily2343733frenzily
frettier1156593frettier
fretting122711523fretting
fretty1249223frett__y
frostily1436693frostily
frothily1745303frothily
fruitily1445143fruitily
greasily1236233greasily
greatly1137613great_ly
greedily1345183greedily
heftily1635763_heftily
knottily1543153knottily
meatily12311093_meatily
nattily103610323_nattily
nettly9459453_nett_ly
nuttily10308633_nuttily
paltrily1345413paltrily
peppily1335133p_eppily
perkily1637813p_erkily
pertly115312553p_ert_ly
peskily1635083p_eskily
petrify1536573p_etrify
pettedly1443893p_ettedly
petti75119453p_etti__
pettier94213613p_ettier
petting103720953p_etting
pettish1238283p_ettish
pettishly1743333p_ettishly
pettle84116053p_ett_le
petty105320293p_ett__y
pithily1567033p_ithily
prattle9208833pratt_le
preachily1945143preachily
preapply1443303preapply
prebill1138803pre_bill
preboil1148953preboil_
preboils1267293preboils
prebuild1344303prebuild
prebuilt1247033prebuilt
prechill1546193prechill
predrill1145933predrill
prefile123413183pre_file
prenotify1744283prenotify
prentice121012353prentice
prepill1147583pre_pill
prestige11310733prestige
pretell938243pre_tell
pretells1047333pretells
pretold1049083pre_told
pretrial10511983pretrial
pretrials1158143pretrials
pretrim11310783pretri_m
pretrims1238983pretrims
prettiest1199803prettiest
prettying1536043prettying
prettyish1743053prettyish
pretzel1835143pretzel_
pretzels1934033pretzels
prevail1238243prevail_
prevails1337663prevails
pricily142710283pr_icily
priestly1345843priest_ly
prissily1346693prissily
privily15207623pr_ivily
prosily12611633pr_osily
rattly94111543_ratt_ly
readily11711403_readily
rectify1536453_rectify
reedily1179613_reedily
reptile93914083_reptile
retail65522073_retail_
retails74718973_retails
retally10413683_retally
retile65929673_re_tile
retitle73913093_retitle
retting83425883_retting
ritzily1945143_ritzily
rustily103112993_rustily
smuttily1344273smuttily
snottily1145553snottily
spottily1335153spottily
sweatily1435473sweatily
tattily10409993_tattily
testily102910803_testily
trendily1256443trendily
trustily11257103trustily
wittily1336173_wittily
wrathily1744773wrathily
zestily19167563_zestily

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.403443402.0
2DLD Change Limit1461621207.06320694.0
3Display Results1201200.0462608.7
 (SQL Overall)1786911207.51223787.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.