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

105 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
reavails113485(None) 
reavail1035641reavail_
avails939692__avails
prevails1337662pre_vails
reassails945292reassails
reavailed1344002reavailed
redtails968002redtails
remails94714562re_mails
renails74917262re_nails
resails74616742re_sails
retails74718972re_tails
travails1146082travails
avail8313883__avail_
bedrails1136293bedrails
bewails1277553be_wails
camails11311753_camails
cavils114014393_cav_ils
derails84216393de_rails
details84214043de_tails
devils104412813de_v_ils
emails84412343_e_mails
entails7912823_entails
ervils948773_erv_ils
evils84114263_e_v_ils
gavials1136603_gavials
headsails1343943headsails
heavies132713873heav_ies
heavily1665903heav_ily
jezails2334163je_zails
kevils13358333ke_v_ils
navaids1134803_navaids
peavies122213403peav_ies
prevail1238243pre_vail_
radials83614643r_adials
rails55937403r___ails
ramtils938413r_amtils
ratals64219583r_ata_ls
rattails837133rattails
ravages1139403r_avages
ravels94717073r_av_els
ravins94622563r_av_ins
readable11313163readable
readably1438383readably
readapts1145583readapts
readies83324713rea_dies
readily11711403rea_dily
readmits1136653readmits
reagins84215643rea_gins
reals55038653re__a_ls
realties8514853realties
reapable12311393reapable
reassail845753reassail_
reatas64021013reata__s
reattains946443reattains
reavailing1444873reavailing
reavers108320743reav_ers
reaves94127573reav__es
reaving113820533reav_ing
reavows1335273reav_ows
reawakes15348073reawakes
rebaits9312573re_baits
reboils94111723re_boils
recalls92613623re_calls
reclaims1236113reclaims
recoals94214623recoa_ls
recoils93814873re_coils
redbaits1135903redbaits
redials84416883redia_ls
redtail858713redtail_
refalls103312243re_falls
refrains1139593refrains
regains84316583re_gains
remail85017123re_mail_
remains94117913re_mains
removals1345653remova_ls
renail65020763re_nail_
rentals74017473renta_ls
renvois1036503renvoi_s
reoils64516873re__oils
repairs9319973re_pairs
repeals94014523repea_ls
resail64418733re_sail_
reseals73917673resea_ls
retail65522073re_tail_
retains74522253re_tains
retrains8314533retrains
retrials8510823retrials
revamps1433993re_vamps
reveals103812723re_veals
revels94220573re_v_els
revile94921613re_v_ile
reviles104421353re_v_iles
revivals1435433reviva_ls
rivals94213183r_iva_ls
seawalls1145233seawalls
serails73318363se_rails
servals103410753serva_ls
tenails73713923te_nails
travail1036553travail_
treenails945563treenails
trenails869843tre_nails
vails85825933___vails
ventails1139823ventails
vervains1435293vervains
weevils1384683weev_ils

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.423422437.4
2DLD Change Limit1461621057.31319986.6
3Display Results1051050.0432441.9
 (SQL Overall)1786911057.77922970.9
 
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.