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

412 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
violets10221000(None) 
piolets93513191piolets
violet92620921violet_
aiglets84012912aiglets
billets94516152billets
filets94718952fi_lets
fillets103414752fillets
giblets103210422giblets
giglets93211552giglets
gimlets10338432gimlets
inlets63915572_inlets
islets64513082_islets
millets94216842millets
piglets103311792piglets
piolet83225642piolet_
riblets93412552riblets
rillets74216152rillets
toilets74112912toilets
triolets83410142triolets
valets93715622v_alets
varlets10411572varlets
veinlets11144832veinlets
vilest9416842vi_lest
violas93713522viol_as
violate10311552violate
violates11311192violates
violent102110812violent
violins10311452violins
violist10312142violist
violists1137662violists
viols86118102viol__s
voiles94616442voile_s
voles86234042v_ole_s
voltes94915582v_oltes
volts85421292v_ol_ts
wiglets113411422wiglets
willets104414322willets
aglets73915683_aglets
aidless83612073aidless
aiglet74224193aiglet_
aigrets82810533aigrets
aimless93610813aimless
aiolis6316843aiol_is
airless73712043airless
aisles64721143aisle_s
amoles84122193amole_s
amulets939923amulets
anklets114310413anklets
anoles64827433anole_s
applets115710063applets
armlets94610063armlets
auklets11298573auklets
avocets1235453avocets
avosets1036663avosets
azoles154614613azole_s
ballets93719513ballets
bibles104617643bible_s
bibless11439173bibless
bidets95215533bi_dets
biles75542143bi_le_s
billers94720833billers
billet86029723billet_
biogens1038963biogens
biomes103815253biome_s
bionts8612393bio_nts
birlers93813003birlers
birles84920643birle_s
blets75324943__blets
boilers93417063boilers
boles75448603_bole_s
bolete8519613_bolete
boletes9316063_boletes
boleti8413403_boleti
boletus948643_boletus
bolts76232113_bol_ts
booklets14247123booklets
boomlets12246673boomlets
bullets93516393bullets
cablets114216343cablets
callets93821703callets
camlets114314623camlets
caplets114914523caplets
chalets122813473chalets
cholents1337623cholents
cholers124215203cholers
circlets1235663circlets
citoles9312553citole_s
civets115212543ci_vets
closets94611603closets
coilers93619903coilers
coles76055063_cole_s
coleus86818273_coleus
collets93517903collets
colts76633293_col_ts
comets105823583_comets
coolers93522493coolers
coolest9318643coolest
cosets85824403_cosets
covets114819643_covets
culets85518513_culets
cullets94015613cullets
cutlets94113653cutlets
dholes104914793dhole_s
dialects11126003dialects
dialers83614303dialers
diets66026643di__ets
diglots9299503diglots
diodes83915783diode_s
diols65521013diol__s
dipnets10109033dipnets
dipoles101013753dipole_s
doles67843753_dole_s
dolts65626313_dol_ts
doolees83711613doolees
driblets11266093driblets
droplets1136063droplets
eaglets84111663eaglets
egoless836983egoless
evilest10310473evi_lest
evillest1146353evillest
eyelets1057523eyelets
fidgets12388763fidgets
filers94623723fi_lers
files85441273fi_le_s
filet85540163fi_let_
fillers104320213fillers
filles94224523fille_s
fillet95027083fillet_
finless102810783finless
florets1039853florets
foleys123810463_foleys
foveolets15103233foveolets
froglets1235263froglets
gallets83517403gallets
gaolers83511563gaolers
gibbets12417723gibbets
giblet93418893giblet_
giglet83920273giglet_
giglots9367863giglots
gillers84216903gillers
gillnets934733gillnets
gilts64924263gi_l_ts
gimlet93716663gimlet_
goblets103210183goblets
godets8410933_godets
goglets9379783goglets
golems939323_golems
guglets9369693guglets
gullets84013713gullets
hamlets123211403hamlets
haoles94919803haole_s
haslets102510863haslets
hillers103718733hillers
hilts86924413hi_l_ts
hipless12399923hipless
hitless103211193hitless
holes84748653_hole_s
holts85627913_hol_ts
hooklets15217203hooklets
howlets13329223howlets
idiolects1243083idiolects
idlers74012813_idlers
idles66720123_idle_s
idlest74014863_idlest
ileus54616893_i_leus
illest63615723_illest
inlet53732403_inlet_
insets64016133_insets
iolite63221983_iolite
iolites73819483_iolites
isles54220563_isle_s
islet54527553_islet_
jilts124717413ji_l_ts
joles125230833_jole_s
jolts125018883_jol_ts
killers114215583killers
kilts95122183ki_l_ts
kinglets13318583kinglets
kinless113310273kinless
kismets13306883kismets
lets47147943___lets
lidless8309273lidless
lilts55822803li_l_ts
limpets11329783limpets
linnets739833linnets
lioness739103lioness
lipless9259553lipless
lisles63416283lisle_s
mallets93318493mallets
midgets113910253midgets
midlegs1156323midlegs
milers84625163mi_lers
miles74645073mi_le_s
millers93621343millers
milles84526563mille_s
millet84030743millet_
milts75430713mi_l_ts
minuets9259853minuets
mioses84318853miose_s
missets94516573missets
moilers93615203moilers
moles74747923_mole_s
molest85022743_molest
molests93311563_molests
molts76032093_mol_ts
mooleys1236863mooleys
moonlets10247473moonlets
motets84216193_motets
mullets93614783mullets
nidgets9358143nidgets
nonets64118703_nonets
nutlets74111253nutlets
oboles83815833obole_s
oilers64721193oi_lers
oleos55419683__oleos
oles46453473__ole_s
omelets938333omelets
orioles7412993oriole_s
outlets73616363outlets
overlets112312363overlets
owlets93110393_owlets
palets85122313_palets
pallets93919303pallets
pellets94014783pellets
pickets154314183pickets
piglet93420923piglet_
piles74742613pi_le_s
pileus84514943pi_leus
pilots84018873pi_lots
pinoles93418703pinole_s
pipets105714773pi_pets
piquets1836603piquets
poets76024443_po_ets
poleis86018353_poleis
polers84225643_polers
poles75351003_pole_s
poolers94217423poolers
projets1639163projets
prolegs10379993prolegs
proles84627203prole_s
pullets94015163pullets
quillets17256823quillets
reflets103513153reflets
reglets83512983reglets
relets64025673_relets
ribless93410343ribless
riblet84222443riblet_
rickets134915093rickets
ridleys11145783ridleys
riflers103512193riflers
rifles94217703rifle_s
riles55343643ri_le_s
rilles64725503rille_s
rillet64828853rillet_
rimless9369363rimless
ringlets92910233ringlets
rioters73615513rioters
riots54922013rio__ts
ripplets12316733ripplets
rivets94417113ri_vets
rivulets1174753rivulets
roles56747983_role_s
rootlets8308653rootlets
rosets65819953_rosets
runlets73310773runlets
sallets73719653sallets
samlets93813553samlets
sidlers83414233sidlers
sidles74721153sidle_s
signets83311503signets
silents73514493si_lents
sillers73822103sillers
silts55330823si_l_ts
singlets93611473singlets
sinless73014213sinless
sippets113310183sippets
skillets12226823skillets
smolts84411883smol_ts
sniglets9276813sniglets
soles55547923_sole_s
soleus64615613_soleus
stoles63927673stole_s
stylets10369213stylets
sublets92616703sublets
tablets94714383tablets
tholes94919783thole_s
tickets134113683tickets
tieless72512563tieless
tilers63523503ti_lers
tiles55542103ti_le_s
tillers73418743tillers
tilts55325613ti_l_ts
tipless92610063tipless
tippets11339373tippets
titles63719923title_s
toilers74116263toilers
toiles63923513toile_s
toilet66228093toilet_
toles55147133_tole_s
tonlets73212503tonlets
toolers74416503toolers
triolet73219523triolet_
triplets103510263triplets
vales85434263v_ale_s
valet84337873v_alet_
valleys13407483valleys
varioles11711123variole_s
varlet9423503varlet_
vaults94511673vaul_ts
vealers103214293vealers
veilers103911823veilers
veinless11136263veinless
veinlet101310573veinlet_
veinulets1243093veinulets
veldts10417753v_eldts
velvets13326693velvets
versets103913103versets
vervets13419753vervets
vets76835093v___ets
vialed105112593viale_d
vials85822383vial__s
vibes104719953vi_be_s
vibists1256483vibists
viceless1337983viceless
vices105725533vi_ce_s
vicomtes1545593vicomtes
videos104911373vi_deos
viers85621953vi__ers
vies75238623vi__e_s
viewers1337173viewers
viewless1434033viewless
views11489643vi__ews
vilayets1443073vilayets
vile76139803vi_le__
vilely1239443vi_lely
viler86324163vi_le_r
villas96117263vi_llas
villein1036753villein
villeins1136043villeins
villous102810023villous
vills86429323vi_l_ls
villus93611223vi_llus
vines85137643vi_ne_s
viniest103216613viniest
viol76523593viol___
viola85915543viol__a
violated1237883violated
violater1137253violater
violaters1245963violaters
violator1146283violator
violators1246583violators
violence1345713violence
violences1445493violences
violently1544333violently
violin9311983viol_in
violone1037153violone
violones1137383violones
vipers114914533vi_pers
vireos94212453vi_reos
vires84529683vi_re_s
virls85618603virl__s
viroses10310533virose_s
vises84427773vi_se_s
visits9311423vi_sits
visorless1243143visorless
vittles103211113vittle_s
vivers124717363vi_vers
vixens16286203vi_xens
viziers19336203viziers
voces105918053v_oce_s
voes75432823v_o_e_s
voicers12348993voicers
voices114414013voice_s
voiders11279823voiders
voile84719723voile__
vole75236983v_ole__
voled95323723v_ole_d
volery1237873v_olery
volleys13316643volleys
volost9412643v_olost
volosts1036563v_olosts
volt76439533v_ol_t_
volta85215623v_ol_ta
volte85321303v_ol_te
volti84915963v_ol_ti
volute93912763v_olute
volutes102710983v_olutes
volvas12447993v_olvas
vomers115614943v_omers
vomits112610923v_omits
voters95017443v_oters
votes84627083v_ote_s
vowels124410483v_owels
vowers124317183v_owers
vowless13246603vowless
wallets103914833wallets
wholes124616773whole_s
wickets164010943wickets
widgets12318453widgets
wigless11359673wigless
wiglet105519153wiglet_
wiles85437873wi_le_s
willers103517913willers
willet95124833willet_
wilts85023503wi_l_ts
winglets12299593winglets
winless103212283winless
witless103310983witless
woolens10398843woolens
woolers104214023woolers
zibets1737743zi_bets
zipless18276303zipless

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.436409841.7
2DLD Change Limit1340274126.25021444.3
3Display Results4124120.1402942.9
 (SQL Overall)1786914126.82626178.0
 
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.