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

215 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
waspily153551(None) 
wispily1535651wispily
campily1638272campily
easily9313022eas_ily
gassily1137812gassily
happily1745762happily
hastily133010662hastily
nastily103011032nastily
sappily1437162sappily
sassily1038722sassily
tastily103311642tastily
wackily1936052wackily
warily122915092wa_rily
waspier12259052waspier
waspish1586922waspish
waspishly2042612waspishly
waspy135410992wasp__y
wavily15219482wa_vily
waxily19218412wa_xily
aerily93017013_aerily
airily93014823_airily
amply125012913_amp_ly
apply125111393_a_pply
aptly105111813_a_ptly
artily92814713_artily
aspic95114733_aspi_c
aspics104211563_aspics
aspire8612123_aspire
aspis74618143_aspi_s
aspish114810333_aspish
baggily1436043baggily
balkily16266693balkily
balmily14216463balmily
basally1237963basally
basely114412313bas_ely
basify1437513bas_ify
basil75122273bas_il_
basils85717473bas_ils
bassly114610073bas_sly
bastile9313913bastile
bawdily1635803bawdily
bossily1237563bossily
brassily1336623brassily
bumpily1665653bumpily
bushily15268893bushily
busily112211503bus_ily
cagily12411563ca_gily
cannily1239263cannily
cattily123210853cattily
classily1336623classily
cosily113613853cos_ily
crispily1574693crispily
cushily15257923cushily
daffily1735133daffily
daily95922333da__ily
damply14337893damp_ly
dandily12279633dandily
daylily1434983daylily
dopily123510463_dopily
dumpily1566233dumpily
duskily15236743duskily
dustily113211523dustily
family143311703fa_mily
fancily1538253fancily
fattily13379463fattily
fishily1637643fishily
flashily1735473flashily
fussily13267603fussily
fustily133111373fustily
gaily95020973ga__ily
gamily123712183ga_mily
gaseity1135113gaseity
gasify1336333gas_ify
gasping113714363gasping
gaspingly1644813gaspingly
gaudily1236523gaudily
gauzily2034393gauzily
gawkily1834093gawkily
glassily1235463glassily
grassily1236433grassily
gushily14257823gushily
gustily113010903gustily
hammily1736063hammily
handily143610873handily
haply135915063ha_p_ly
hardily143310273hardily
hasping134414903hasping
hazily2179063ha_zily
huskily17236333huskily
jaspery19405253jaspery
jazzily2533373jazzily
jumpily2174983jumpily
lacily11612763la_cily
lankily1437123lankily
lastly93310873las_tly
lazily1859713la_zily
loopily1236803loopily
lumpily1476563lumpily
lustily103611243lustily
mangily1339753mangily
manlily1238743manlily
mazily20610393ma_zily
messily12298813messily
mistily122612343mistily
mushily152410093mushily
muskily16289043muskily
mussily12279773mussily
mustily123613633mustily
nasally1057443nasally
nattily103610323nattily
nippily1444713nippily
nosily93712683nos_ily
pastil85018323pastil_
pastils94416173pastils
pawkily1934203pawkily
peppily1335123peppily
peskily1635083peskily
pily96132733___pily
pulpily1436103pulpily
pushily15247983pushily
racily11715173ra_cily
rainily10310433rainily
rapidly1336523ra_pidly
raptly11338913ra_ptly
rashly123410213ras_hly
raspier93110633raspier
rasping104316253rasping
raspingly1535813raspingly
raspish1298103raspish
raspy106511703rasp__y
riskily1436413riskily
ropily113312443_ropily
rosily93914713ros_ily
roupily1246653roupily
rustily103112993rustily
saltily10310543saltily
saucily1237913saucily
savvily1634323savvily
shily115222013__shily
slily85820033__slily
snappily1544323snappily
soapily1237963soapily
spicy125417713__spicy
spiky146014113__spiky
spile75230083__spile
spill74821163__spill
spilt75532223__spilt
spiny104921303__spiny
spiry105017353__spiry
swankily1833833swankily
tackily1637503tackily
tardily11269583tardily
tartily103511573tartily
tattily10409993tattily
tawnily1335443tawnily
testily102910803testily
tipsily1236043tipsily
trashily1437323trashily
unspilt938853unspilt
vapidly1635063va_pidly
vastity1336203vastity
vastly12508723vas_tly
wabbly16348363wa_bbly
waddly14478723wa_ddly
waffly18305433wa_ffly
waggly14347293wa_ggly
wail75238823wa__il_
wails86631483wa__ils
wally114625093wa__lly
waly105830903wa___ly
wambly16388663wa_mbly
wampish1777293wampish
wanly115118023wa__nly
wapiti1138363wa_piti
wapping153514603wapping
warmly14228063wa_rmly
warping133715183warping
washday1743383washday
washier133611153washier
washing145119283washing
washy145911843was__hy
wasp95626853wasp___
waspiest1338813waspiest
wasplike1734893wasplike
wasps106714693wasp__s
wassail1056133wassail_
wassails1145953wassails
wastery134610993wastery
wasting114422843wasting
wastingly1636353wastingly
wastry12388773was_try
waterily1438783waterily
waxbill1943133waxbill
waybill1543723waybill
wearily1338783wearily
weaselly14284373weaselly
weasely13317853weas_ely
weedily1476123weedily
weevily1694643weevily
wilily123310763w_ilily
wily106428813w___ily
windily1437943windily
wirily123310783w_irily
wisely122711713wis_ely
wispier12249403wispier
wisping133711943wisping
wispish1575643wispish
wispy137210973wisp__y
wittily1336173wittily
woozily2234383woozily
wordily1437853wordily
wrathily1744773wrathily
yeastily1444573yeastily
zanily18310183za_nily
zestily19167563zestily

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.1561145455.1
2DLD Change Limit1340272158.34316064.6
3Display Results2152150.0762828.9
 (SQL Overall)1786912158.57520838.6
 
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.