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

112 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
awardee113756(None) 
awarded1236221awarded
awardees1243991awardees
awarder1135891awarder
award97118042award__
awarders1245072awarders
awards107113452award_s
aware86420022awar__e
pardee93922022_pardee
swarded1238152swarded
warded115021042_warded
warden104515512_warden
warder104020272_warder
abrade9313053abrad_e
abraded1138643abraded
abrader1038643abrader
abrades10312073abrades
academe1244703aca_deme
acarine9316003acarine
agarose838673agarose
agree65226033a_gr_ee
alarmed1037743alarmed
amarone9311203amarone
anadem939183ana_dem
ardeb8314523__ardeb
avarice1238033avarice
awaited1146963awaited
awaiter1057443awaiter
awake125014783awa__ke
awaked14579203awa_ked
awaken13468863awa_ken
awakes135012473awa_kes
awardable1543953awardable
awarding1356043awarding
awee76336643aw___ee
awkwarder2051633awkwarder
barde85330773_bard_e
barded105426423_barded
bardes95026933_bardes
bargee94624443_bargee
bearded114212133bearded
boarded113910503boarded
boarder103910323boarder
carded105424903_carded
carder94524183_carder
dwarfed1533483dwarfed
dwarfer1433683dwarfer
dwarves1434463dwarves
farded114518953_farded
fardel104712593_fardel
garden84215083_garden
grandee93115513grandee
guarded1036153guarded
guarder936463guarder
harden105718533_harden
harder105022403_harder
hazarded2243643hazarded
hazarder2143603hazarder
hoarded12368343hoarded
hoarder11329233hoarder
larded84319093_larded
larder73720973_larder
laree56036293_lar_ee
pardie96021443_pardie
rewarded13229523rewarded
rewarder12208233rewarder
saree55044663_sar_ee
standee83514513standee
swaddle12276743swaddle
sward94221463sward__
swards105415133sward_s
sware85828213swar__e
swarmed1367483swarmed
swarmer1247803swarmer
tabarded1234743tabarded
twaddle12245713twaddle
unawarded1444923unawarded
vaward13498723vaward__
vawards14457573vaward_s
wadded124014173_wadded
wadder114215483_wadder
waddie114013323_waddie
waddle114715303_waddle
wade85237063_wa_d_e
waded106024753_wa_ded
wader95325363_wa_der
wades95634143_wa_des
wander104423713_wander
wandle105316663_wandle
warble113516603_warble
ward86542253_ward__
wardens113711903_wardens
warders113416813_warders
wards97734403_ward_s
ware76254723_war__e
wared96339873_war_ed
wares88250583_war_es
warier93722893_warier
warked144421213_warked
warmed124516893_warmed
warmer113816733_warmer
warned104018913_warned
warner93717223_warner
warped124816413_warped
warper114015583_warper
warred104019843_warred
warren95012853_warren
warsle93112923_warsle
warted104223233_warted
worded114316623_worded
yarded114714023_yarded
yarder103813973_yarder

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 Filter1786911340270.436409841.7
2DLD Change Limit1340271126.69020033.9
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.17224915.1
 
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.