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

194 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
unvext165817(None) 
invent93316362invent
invert94120082invert
invest93014842invest
next116631082_n_ext
unbelt83015692unbelt
unbent83216592unbent
unfelt92413462unfelt
unfixt16398422unfixt
unkent103116052unkent
unkept123710872unkept
unlet54133332unle_t
unmeet83815742unmeet
unmet74426392unme_t
unmixt15378702unmixt
unpent83117372unpent
unrent63219782unrent
unrest62918852unrest
unseat64221022unseat
unsent63820962unsent
unset54532432unse_t
unsex123512632unsex_
unsexy16296902unsexy
unveil957342unveil
unvexed18147102unvexed
unwept11389812unwept
unwet84423172unwe_t
urtext1337432urtext
vext146927762__vext
advect12309123advect
advent102613753advent
advert103215773advert
anent54931843an_ent
annex12310883annex_
annexe1337813annexe
avert86029493_avert
caveat11417723caveat
civet105828733cive_t
context163913433context
convect143114483convect
convent123919413convent
convert123721473convert
convex18367743convex_
covert114925503covert
covet105638943cove_t
culvert123011773culvert
curvet114720243curve_t
devest104418703devest
divert103922813divert
divest106820073divest
dunnest83312263dunnest
duvet9321873duve_t
event85924443_event
evert84929513_evert
funest94316863fun_est
funfest13348083funfest
funnest102912003funnest
incent83320723incent
incept102712753incept
incest82918743incest
indent73021243indent
index13310983index_
inept73622153in_ept
inert53234373in_ert
infect113413443infect
infest93315433infest
ingest73119003ingest
inject153210233inject
inlet53732403inle_t
insect83916583insect
insert64325253insert
inset54430863inse_t
intent63122773intent
invents102812053invents
inverts103211953inverts
invests10319683invests
junket173815023junke_t
knelt94617683kn_elt
livest95315733livest
lunet56835423lun_e_t
luniest73516993luniest
neat46356783_n_eat
nest45548733_n_est
net36670293_n_e_t
nett46643233_n_ett
newt76933743_n_ewt
nudest74113833nudest
obvert11412993obvert
oncet74626543once_t
onset54730173onse_t
overt85630723_overt
pungent10311233pungent
puniest92918093puniest
punkest132611693punkest
punnet83518843punne_t
revert93529113revert
revest94623603revest
revet84938843reve_t
rivet85636363rive_t
runlet63821413runle_t
sext117338093__sext
suavest10310623suavest
subtext1647653subtext
subvert12312893subvert
sunbelt939233sunbelt
sunket103721363sunke_t
sunset63723633sunse_t
text116033933__text
unadept1046603unadept
unapt710421593un_apt
unaxed144113093unaxed
unbe65319273unbe__
unbear889163unbear
unbelts9237663unbelts
unbend9269773unbend
unblest9411813unblest
unbolt83013893unbolt
unbox1438753unbox_
uncast84215713uncast
uncleft1257493uncleft
uncut73219173un_cut
unde55825483unde__
undead82711903undead
undee65327273unde_e
under64624213unde_r
undrest8313013undrest
uneven957913uneven
unfed94614223unfe_d
unfit84518563un_fit
unfix15429033unfix_
ungirt71112713ungirt
ungot61718063un_got
unguent839123unguent
unhat81119263un_hat
unhelm1136863unhelm
unhewn12285253unhewn
unhurt9311253unhurt
unisex1358353unisex_
unit45140073un__it
unjust1337873unjust
unkempt1544763unkempt
unkend11309223unkend
unknit1068593unknit
unknot1037413unknot
unlead73312373unlead
unled64021073unle_d
unless62413073unless
unlit55025463un_lit
unmeant9510903unmeant
unmesh1145793unmesh
unmew103610073unme_w
unmews11326523unmews
unmix14388973unmix_
unpeg8309363unpe_g
unpegs9256233unpegs
unpen72913573unpe_n
unpens82511013unpens
unread73412673unread
unreal64414453unreal
unreel63612933unreel
unrests7229463unrests
unroot6315553unroot
unseal63315473unseal
unseam83313143unseam
unseats73012853unseats
unseen62012623unseen
unsell63512543unsell
unsets64116163unsets
unsew83912693unse_w
unsewn9298393unsewn
unsews9379363unsews
unsexed152410253unsexed
unsexes14248923unsexes
unshut939013unshut
unspent92610893unspent
unswept1246013unswept
unveils1045753unveils
unvested122210223unvested
unwed94114873unwe_d
unwell9349443unwell
unwit84417523un_wit
upbeat10911513upbeat
upsent83314063upsent
upset73222593upse_t
urgent73816043urgent
urtexts1433143urtexts
uvea74712653u_ve_a
uveal84411073u_veal
uveas84912283u_veas
vent76049053__vent
vert77249373__vert
vest75743603__vest
vet65958523__ve_t
vex136429173__vex_

Search took 6 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 Filter1786911127160.1261418182.5
2DLD Change Limit1127161945.70319764.3
3Display Results1941940.0603233.3
 (SQL Overall)1786911945.88930343.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.