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

127 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
sweepiest143567(None) 
seepiest102412621s_eepiest
sleepiest1136711sleepiest
weepiest13219471_weepiest
creepiest1337062creepiest
dweebiest1542662dweebiest
seediest92714052s_eediest
sheeniest12158352sheeniest
sleekiest1336062sleekiest
sleetiest938552sleetiest
sneeriest939302sneeriest
sneeziest1845142sneeziest
speediest1257462speediest
steeliest939632steeliest
steepest1038122steep_est
swampiest1635022swampiest
sweatiest1238412sweatiest
sweenies11148762sweenies_
sweepier1355492sweepie_r
sweetest1137172swee_test
sweeties11159722sweeties_
swoopiest14155382swoopiest
tweediest1344272tweediest
weediest122311132_weediest
weeniest112411212_weeniest
weepies122811742_weepies_
beefiest13269013_beefiest
beeriest104013403_beeriest
breeziest2035063breeziest
cheekiest1835703cheekiest
cheeriest1438213cheeriest
cheesiest1436323cheesiest
creepies1239613creepies_
crepiest12310383_crepiest
deediest102912253_deediest
deepest10310443_deep_est
eeliest73516473__eeliest
eeriest73620673__eeriest
fleeciest1434873fleeciest
geekiest13257863_geekiest
gleetiest1035913gleetiest
greediest1147553greediest
greeniest1039033greeniest
hempiest1539023_hempiest
leeriest83112883_leeriest
neediest92611303_neediest
peppiest11278563_peppiest
preppiest1236973preppiest
reediest92815423_reediest
reefiest112811483_reefiest
reekiest122711313_reekiest
sappiest122612573s_appiest
screwiest1445463screwiest
seamiest102715413s_eamiest
sedgiest10259763s_edgiest
seemliest1145613seemliest
seepier92912013s_eepie_r
sexiest142112223s__exiest
sheenies111411543sheenies_
sheepish1645413sheepi_sh
sheerest11310083shee_rest
shelliest1238013shelliest
shelviest1535003shelviest
sirupiest1154753sirupiest
skimpiest1734503skimpiest
sleaziest1836053sleaziest
sleekest1236153slee_kest
sleepier1036783sleepie_r
sleepiness1245133sleepiness
sleepless1144553sleepless
slippiest1346463slippiest
sloppiest1345973sloppiest
smeariest1138113smeariest
smelliest1136593smelliest
snappiest1346483snappiest
sneakiest13176823sneakiest
snippiest1345713snippiest
snoopiest11157053snoopiest
soapiest102412843s_oapiest
soppiest122511933s_oppiest
soupiest102212903s_oupiest
spendiest1237523spendiest
spheriest1438373spheriest
spleeniest1264293spleeniest
steadiest1038513steadiest
steamiest1138403steamiest
steelies8312553steelies_
steepish1375823steepi_sh
steeples1038013steeples_
steepness1145713steepness
stemmiest1335143stemmiest
stripiest1138013stripiest
stumpiest1335843stumpiest
swankiest16136203swankiest
sweeper12329373sweep_e_r
sweepers13348163sweep_ers
sweeping14389143sweepi_ng
sweepings15345633sweepings
sweeps114110513sweep__s_
sweetie10157863sweetie__
sweetish1445373sweeti_sh
sweetmeat1442823sweetmeat
sweetness1245683sweetness
swellest1137663sw_ellest
sweltriest1343283sweltriest
swimmiest1634253swimmiest
swingiest13207573swingiest
swirliest1236283swirliest
swishiest1535513swishiest
swooniest12176293swooniest
syrupiest1453223syrupiest
teeniest82112413_teeniest
tweakiest1634053tweakiest
tweenies11146393tweenies_
waspiest1338813_waspiest
weariest112914793_weariest
webbiest1535353_webbiest
wedgiest13307983_wedgiest
weenies102915093_weenies_
weensiest1244743_weensiest
weepie11258793_weepie__
weepier12319273_weepie_r
weepiness14215963_weepiness
wenniest11259593_wenniest
wheeziest2443663wheeziest
wimpiest1538763_wimpiest
wispiest1339513_wispiest

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411277.37320160.2
3Display Results1271270.0632015.9
 (SQL Overall)1786911277.59223536.7
 
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.