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

170 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
prevails133766(None) 
prevail1238241prevail_
preboils1267292preboils
prevailed1536042prevailed
prevailer1445152prevailer
prevailers15123832prevailers
reavails1134852_reavails
remails94714562_remails
renails74917262_renails
resails74616742_resails
retails74718972_retails
travails1146082travails
trenails869842trenails
avails939693__avails
bewails1277553_bewails
brails84621293br__ails
coevals1237883coeva_ls
cremains1238693cremains
crevalle1346163crevalle
crevalles1455723crevalles
derails84216393_derails
details84214043_details
devils104412813_dev_ils
drails74716953dr__ails
emails84412343__emails
ervils948773er_v_ils
evils84114263__ev_ils
foresails1247153foresails
frails93716473fr__ails
grails77518783gr__ails
gremials1136133gremials
jezails2334163_jezails
kevils13358333_kev_ils
pails75833063p___ails
parasails1147583parasails
peals75235493p_e_a_ls
pearls84715393p_e_arls
peavies122213403p_eavies
pedals94316033p_eda_ls
pencils113011773p_encils
pensils92811593p_ensils
perils84121853p_e_rils
pertains102113423pertains
pervades1437353pervades
petals84719813p_eta_ls
pigtails1146033pigtails
pintails10310163pintails
pluvials1343713pluvials
preacts113211363pre_acts
preamps1336613pre_amps
prearms11369173pre_arms
preavers13910263preavers
prebakes1639013prebakes
prebids12399883pre_bids
prebill1138803pre_bill
prebills1237293prebills
preboil1148953preboil_
prebuild1344303prebuild
prebuilds1442633prebuilds
prebuilt1247033prebuilt
precasts1239453precasts
prechill1546193prechill
prechills1645123prechills
precis103416703pre_ci_s
precools1237703precools
predates11615813predates
predawns1444363predawns
predial103815413predial_
predries112714383predries
predrill1145933predrill
predrills1244473predrills
preedits1168763preedits
preemies12512193preemies
prefabs1435163prefa_bs
prefaces15311063prefaces
prefades1439533prefades
prefile123413183pre_file
prefiles133113443pre_files
pregames1339003pregames
prelacies13310053prelacies
prelates10418573prelates
prelims1139823pre_lims
premies113823063pre_mies
premiss113513813pre_miss
prenames12311643prenames
prepacks1836583prepacks
prepaid12310133prepai_d
prepares122014163prepares
prepaves15189193prepaves
prepays1437483prepa_ys
prepill1147583pre_pill
preppies1149693preppies
preppily1444593preppily
prequels1934833prequels
presages11312203presages
presale9416353presa_le
presales10315263presales
presells1058283presells
preships1539313preships
pretapes122811533pretapes
pretells1047333pretells
pretrains11410143pretrains
pretrials1158143pretrials
pretrims1238983pretrims
pretties10615133pretties
prettily1337283prettily
pretzels1934033pretzels
prevailing1656723prevailing
prevalue1345073prevalue
prevalues1445323prevalues
prevents133012293prevents
preverbs15295303preverbs
previable1647533previable
preview1536473prev_iew
previews1634513previews
previous1337823previous
previse123713793prev_ise
previses133814283previses
previsits1446793previsits
prevues1239263prev_ues
prevuing1457253prevuing
prewarms15406733prewarms
prewarns13456943prewarns
prexies163415003pre_xies
privacies1646803privacies
privates131812373privates
privies122414263priv_ies
privily15207623priv_ily
provable1539093provable
provably1846213provably
rails55937403_r__ails
reals55038653_re_a_ls
reavail1035643_reavail_
rebaits9312573_rebaits
reboils94111723_reboils
recalls92613623_recalls
recoils93814873_recoils
redials84416883_redials
redtails968003_redtails
refalls103312243_refalls
regains84316583_regains
remail85017123_remail_
remains94117913_remains
renail65020763_renail_
reoils64516873_re_oils
repairs9319973_repairs
resail64418733_resail_
retail65522073_retail_
retains74522253_retains
revamps1433993_revamps
reveals103812723_reveals
revels94220573_rev_els
revile94921613_rev_ile
reviles104421353_rev_iles
rivals94213183_riva_ls
serails73318363_serails
servals103410753serva_ls
tenails73713923_tenails
toenails847213toenails
trails64622513tr__ails
travail1036553travail_
treenails945563treenails
trefoils1145303trefoils
trenail7410813trenail_
trevally1446343trevally
trevallys1542213trevallys
trysails1144163trysails
vails85825933___vails
vervains1435293vervains
weevils1384683weev_ils

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621707.83018666.9
3Display Results1701700.0602833.3
 (SQL Overall)1786911708.32621461.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.