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

153 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
unveils104575(None) 
unveil957341unveil_
anvils9219712anv_ils
surveils1144522surveils
uncoils979532uncoils
unnails738222unnails
unreels7258312unreels
unseals73212572unseals
unsells73210772unsells
unveiled1298162unveiled
veils84918802__veils
abseils935973abseils
angels74416173ange_ls
anils56326723an__ils
anneals7449943anneals
anvil82712603anv_il_
avails939693_avails
bevels113913983beve_ls
cavils114014393cav_ils
ceils75019403__ceils
deils65722863__deils
deveins1138813deveins
devels104313903deve_ls
devils104412813dev_ils
entails7912823entails
entoils7810733entoils
enviers1036993enviers
envies9314053env_ies
envois988703envoi_s
ervils948773erv_ils
evils84114263_ev_ils
funnels10348173funne_ls
gavels105911093gave_ls
gneiss765953gn_eiss
gunnels8358563gunne_ls
gunsels8338133gunse_ls
heils85222193__heils
hovels125413333hove_ls
instils7811453instils
inveigh1443713inveigh
inveighs1542743inveighs
inveigle1243973inveigle
inveigles1343023inveigles
invents102812053invents
inverts103211953inverts
invests10319683invests
kevels134410713keve_ls
kevils13358333kev_ils
kneels10408933kn_eels
knells10439253kn_ells
kvells13346613_kvells
levels94113283leve_ls
nails55730403_n_ails
navels95712693nave_ls
neifs85613043_n_eifs
nihils937573_nihils
nils46132453_n__ils
noels56418703_noe_ls
noils55024333_n_oils
novels95512503nove_ls
ravels94717073rave_ls
reveals103812723reveals
revels94220573reve_ls
runnels7329153runne_ls
snails64816653sn_ails
snells64614203sn_ells
snivels10336903snive_ls
speils84116223_speils
surveil1045093surveil_
tunnels7328723tunne_ls
umbels104510593umbe_ls
unagile838283unagile
unais53420773un_ai_s
unbears998043unbears
unbeing1039373unbeing
unbelt83015693unbe_lt
unbelts9237663unbelts
unbends10236993unbends
unbuild1035723unbuild
unbuilds1143153unbuilds
unbuilt948003unbuilt
uncials92510523uncials
unclips1136433unclips
uncoil8811853uncoil_
uncurls937123uncurls
undies73821963un_dies
unevenly1444613unevenly
unfelt92413463unfe_lt
unfits93910293un_fits
unfurls1035573unfurls
unguis738453ungui_s
unhairs1036373unhairs
unhelm1136863unhe_lm
unhelms1234223unhelms
unifies102714713unifies
unities72520153unities
units54923433un__its
unknits1135553unknits
unleads8228623unleads
unless62413073unle_ss
unlevels1143803unlevels
unmews11326523unme_ws
unnail6410583unnail_
unpegs9256233unpe_gs
unpens82511013unpe_ns
unpile81914323un_pile
unpiles92112783un_piles
unpins82312383un_pins
unravels1144633unrave_ls
unreal64414453unreal_
unreel63612933unreel_
unrests7229463unrests
unrigs7159003un_rigs
unrips8199453un_rips
unrolls797793unrolls
unseal63315473unseal_
unseams9338913unseams
unseats73012853unseats
unsell63512543unse_ll
unsets64116163unse_ts
unsews9379363unse_ws
unsexes14248923unsexes
unshells1145923unshells
unships1237203unships
unspilt938853unspilt
unsteels845793unsteels
unties64326923un_ties
until53517743un_til_
untrims938613untrims
unveiling1337723unveiling
unveilings1443103unveilings
unveined1258003unveined
unvexed18147103unvexed
unvext1658173unve_xt
unvoice12126153unvoice
unvoices13125163unvoices
unwell9349443unwe_ll
unwits9389893un_wits
unzips17175273un_zips
upboils1184703upboils
upcoils1184933upcoils
upwells12244303upwells
uracils939373uracils
uveal84411073u_veal_
uveas84912283u_ve_as
uveitis1043683u_veitis
uveous936603u_veous
vails85825933__vails
veals84926193__veals
veil75523593__veil_
veins84620493__veins
vexils1647173__vexils
weevils1384683weevils

Search took 7 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.406440125.6
2DLD Change Limit1340271536.29621287.6
3Display Results1531530.0463326.1
 (SQL Overall)1786911536.74826480.6
 
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.