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

125 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
reavail103564(None) 
reavails1134851reavails
avail8313882__avail
prevail1238242pre_vail
reassail845752reassail
reavailed1344002reavailed
redtail858712redtail
remail85017122re_mail
renail65020762re_nail
resail64418732re_sail
retail65522072re_tail
travail1036552travail
avails939693__avails
bedrail1037253bedrail
bewail1189583be_wail
camail10314833_camail
cavil103816493_cav_il
deasil71110983dea_sil
derail74218813de_rail
detail74516433de_tail
devil94714733de_v_il
email74715103_e_mail
entail61114343_entail
ervil8310303_erv_il
evil75318073_e_v_il
gavial10310083_gavial
headsail1244423headsail
heavily1665903heav_ily
jezail2234643je_zail
kevil12399863ke_v_il
meatal84114733meata_l
navaid1037653_navaid
naval85315833_nava_l
preanal9310713preana_l
preaxial1746973preaxial
precaval1544723precava_l
prevails1337663pre_vails
racial83419243r_acial
radial74020393r_adial
rail46147763r___ail
ramal74622243r_ama_l
ramtil8311023r_amtil
ratal55025113r_ata_l
rattail737803rattail
ravage1039303r_avage
ravel84621513r_av_el
ravin85624653r_av_in
readable11313163readable
readably1438383readably
readapt1039743readapt
readily11711403rea_dily
readmit1039823readmit
reaffix2042323reaffix
reagin74915533rea_gin
real45750293re__a_l
realia6314593rea_lia
reapable12311393reapable
reassails945293reassails
reata54225393reata__
reatas64021013reata_s
reattain846733reattain
reavailing1444873reavailing
reave84528023reav__e
reaved104523923reav_ed
reaver94524733reav_er
reavers108320743reavers
reaves94127573reav_es
reaving113820533reaving
reavow1235723reav_ow
reavows1335273reavows
reawake14457893reawake
rebait8320403re_bait
reboil83814683re_boil
recall83815723re_call
reclaim1137753reclaim
recoal84117973recoa_l
recoil84016723re_coil
rectal84418133recta_l
redbait1039803redbait
redial74923113redia_l
redtails968003redtails
refall94314393re_fall
refrain10310043refrain
regain74517763re_gain
regal65023793re_ga_l
regnal74812933regna_l
relaid75518443re_laid
remails94714563re_mails
remain85919863re_main
removal1236733remova_l
renails74917263re_nails
renal55929503re_na_l
rental63922023renta_l
renvoi945863renvoi_
renvois1036503renvois
reoil55321183re__oil
repaid94716323re_paid
repair84011463re_pair
repeal84718283repea_l
resaid74517083re_said
resails74616743re_sails
reseal64819643resea_l
retails74718973re_tails
retain64523283re_tain
retial64724993retia_l
retrain7615423retrain
retral64419743retra_l
retrial7615553retrial
revamp1336013re_vamp
reveal94115053re_veal
revel84423163re_v_el
revile94921613re_v_ile
revival1337033reviva_l
rival85216503r_iva_l
seawall1046203seawall
serail64222673se_rail
serval93913413serva_l
tenail64516113te_nail
travails1146083travails
treenail846123treenail
trenail7410813tre_nail
vail75432553___vail
ventail10310453ventail
vervain1335563vervain
weevil1295433weev_il

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.1401276364.3
2DLD Change Limit1340271257.08018930.4
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.26624592.8
 
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.