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

304 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
envois98870(None) 
envoi878021envoi_
envoys1255131envoys
renvois1036501renvois
endows104610422endows
enjoin1357832enjoin
enjoins1457332enjoins
enjoys1644602enjoys
ennuis636472ennuis
enokis103010272enokis
enols54718402en_ols
enosis63816422enosis
enows85115492en_ows
enrols61213382enrols
entoil6912492entoil
entoils7810732entoils
envies9314052envies
envious1037222envious
envoy1156712envo_y
nevoid1098792nevoid
renvoi945862renvoi_
aeneous739893aeneous
animis84615943animis
anions64123033anions
anis45746463an__is
annoys967523annoys
anoas57226493an_oas
antis55033313an_tis
anvil82712603anv_il
anvils9219713anvils
anyons94513503anyons
arvos86015663arvo_s
avoid95516673_avoid
avoids104410203_avoids
avos77227013_avo_s
avows114910983_avows
bennis84314803ben_nis
bentos86218303bento_s
benzoic2045033benzoic
benzoin1846263benzoin
benzoins1945573benzoins
benzols1836673benzols
bevors111610343bevors
censors93611833censors
centos85920463cento_s
convoys15267023convoys
dentoid9310663dentoid
devoid1189353devoid
devoir1076033devoir
devoirs1175783devoirs
devons104512253devons
divots104712203divots
eaves85231993eav_es
ebons74316093e_bons
ebooks12358333ebooks
ecesis84611203ecesis
echoes114715523echoes
echoic1339043echoic
echoism1447363echoism
echos105216463echo_s
eddoes8199143eddoes
egis56520653e__gis
egoism977473e_goism
egoist7612283e_goist
egos55821653e_go_s
eidos65817753eido_s
eikons1038503eikons
elbows1196713elbows
elemis8312383elemis
elevons1067573elevons
eloin55923203e_loin
eloins65419383e_loins
elvers93814983elvers
elves85118743elv_es
elvish1277563elv_ish
emboss1087383emboss
embows1396823embows
emesis84712623emesis
enacts84012973enacts
enamors939123enamors
enates64026423enates
enatic8317563enatic
encode9310443encode
encodes10310643encodes
encomia1147983encomia
encore8314773encore
encores9315213encores
enders74324053enders
endorse879203endorse
endow94510983endo_w
endrin7312403endrin
endrins8312163endrins
ends56528523en__ds
endues73813903endues
endwise1136463endwise
enemas8812003enemas
enemies9313693enemies
enfold10137613enfold
enfolds11136253enfolds
english1137953english
engross837123engross
engs56121393en__gs
enjoy1545963enjo_y
enlist6417043en_list
ennui537523ennui_
enoki9268873en_oki
enol45823823en_o_l
enolic8413353enolic
enorm74415633en_orm
enow77819873en_o_w
enrobe86610793enrobe
enrobes92211113enrobes
enrol51014283enro_l
enroll61110073enroll
enrolls7108093enrolls
enroot6615993enroot
enroots738713enroots
ens37245923en___s
enskies1138573enskies
ensoul638253ensoul
ensouls736033ensouls
ensues63313813ensues
entail61114343entail
entails7912823entails
entasis73012573entasis
enters64425643enters
entia5318203en_tia
entomb1037363entomb
entombs1135613entombs
entopic1149953entopic
entries71523163entries
entwist1048803entwist
enures63919713enures
envelops1343493envelops
envenoms1343853envenoms
envied1038833envied
envier939673envier
enviers1036993enviers
enviro936303enviro
environs1144673environs
enviros1034913enviros
envy10411253env__y
envying1435713envying
enwomb1344973enwomb
enwombs1443633enwombs
enzyms2063433enzyms
eons46638713e__ons
ephods1238363ephods
ephors11311403ephors
epos66723733e_po_s
ergots74512373ergots
eros45238453e_ro_s
errors63311313errors
ervil8310303erv_il
ervils948773ervils
escots84211743escots
essoin638193essoin
essoins737603essoins
estops84011223estops
ethos85514193etho_s
etuis54013133e_tuis
euros54920243euro_s
evens84817103e_vens
eves76230463e_v_es
evil75318073e_v_il
evils84114263e_vils
evoke12478853e_voke
evokes13459683e_vokes
exons125813343e_xons
expos1449203expo_s
extols1337683extols
favors124211403favors
fervors1336233fervors
gavots1038103gavots
genesis82510823genesis
genoas74013623gen_oas
genoise839423gen_oise
genoms94412483gen_oms
genros74211333genro_s
gentoos838633gentoos
gnosis75711213gnosis
havocs1435653havocs
incogs937903incogs
indols74714203indols
indows104210793indows
indris7311953indris
infos84311673info_s
ingots7912063ingots
inions64417003inions
intis55121643in_tis
invars9310003invars
invoice12136243invoice
invoices13135863invoices
invoke1336213invoke
invokes1436383invokes
kendos114510663kendo_s
kenos95220623ken_o_s
kenosis11369003kenosis
knobs11519713kn_obs
knops115911813kn_ops
knots95614723kn_ots
knows124912413kn_ows
kois85129393__kois
lenis56326863len__is
lenos56024863len_o_s
lentoid8310683lentoid
lentoids947443lentoids
lentos65317403lento_s
levis85818553lev_is
mavis105622723mav_is
mentors9314993mentors
nabis76020583_nabis
naoi46024633_naoi_
naos47429733_nao_s
naris55735293_naris
nazis145216083_nazis
neons55818683_neons
nereis6315343nereis
nerolis71012773nerolis
nerols6914883nerols
nervous1037143nervous
netops839213netops
neves87021873nev_es
nevi75116423nev_i_
nevus84611393nev_us
nobs66436903_n_obs
nods55838223_n_ods
noes45845393_n_oes
nogs56534613_n_ogs
noil46133243_n_oil
noils55024333_n_oils
noir46722433_n_oir
noirs55615463_n_oirs
noise55723733_n_oise
noisy86813363_n_oisy
noms65636403_n_oms
nooks95420393_nooks
noons54125283_noons
noris54928273_noris
nos38859323_n_o_s
nous46136983_n_ous
novas85215363_novas
nows75738233_n_ows
onions64016433onions
onos46229003on_o_s
ovoid94811023_ovoid
ovoids10456923_ovoids
patois84319363patois
pavis106422733pav_is
pelvis113610323pelv_is
pengos94612413pengo_s
penis75129323pen__is
pennis84315743pen_nis
pennons939713pennons
pivots115111903pivots
pois66539043__pois
reavows1335273reavows
savors95616103savors
savoys12427893savoys
senhors103512123senhors
seniors73413613seniors
senors63620783sen_ors
senseis73310643senseis
sensors73514623sensors
servos93812723servo_s
snobs74716153sn_obs
snogs66017493sn_ogs
snoods74312443snoods
snooks104412823snooks
snools65715873snools
snoops84314163snoops
snoots64216663snoots
snots55225103sn_ots
snows84719883sn_ows
tendons8311473tendons
tennis64015303ten_nis
tenons62916603ten_ons
tenors63217753ten_ors
tensors72712373tensors
tenuis64213083ten_uis
tenuous738473tenuous
travois1037873travois
trois57226093_trois
unais53420773un_ais
uncoil8811853uncoil
uncoils979533uncoils
uncos74117033unco_s
undoes73917403undoes
unguis738453unguis
unions64216753unions
unnoisy1044243unnoisy
unveil957343unveil
unveils1045753unveils
unvoice12126153unvoice
unvoices13125163unvoices
vendors113510223vendors
venoms114211213ven_oms
venous93713193ven_ous
vis66747613__v_is
voes75432823__voes
void86220563__void
voids95414673__voids
vows106626943__vows
xenons132710483xen_ons

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163046.05018630.7
3Display Results3043040.0933268.8
 (SQL Overall)1786913046.28328440.4
 
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.