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

282 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
violate1031155(None) 
violated1237881violated
violater1137251violater
violates11311191violates
cholate122114932cholate
dilate73220692di_late
etiolate849522etiolate
folate93320392_folate
inviolate1246392inviolate
iodate7313502_iodate
iolite63221982_iolite
isolate7313922isolate
niobate937702niobate
prolate9419792prolate
reviolate1248122reviolate
solate64526072_solate
vallate103016562vallate
variolate1248552variolate
velate93720142v_elate
vibrate122811522vibrate
villae95615382villa_e
village113610832village
viola85915542viola__
violable1337542violable
violas93713522viola_s
violaters1245962violaters
violative1545112violative
violator1146282violator
violet92620922violet_
violets102210002violets
violone1037152violone
virgate1138732virgate
vitiate103412952vitiate
vittate10409732vittate
volante1038512v_olante
volte85321302v_ol_te
volute93912762v_olute
volvate13317992v_olvate
ablate82219213_ablate
acolyte12157653acolyte
acylate12310533acylate
adulate8313233adulate
airdate8311323airdate
alate55340333__alate
alveolate1244413alveolate
anolyte10159003anolyte
apholate13410473apholate
areolate81014453areolate
arillate8412993arillate
aviate9315203avi__ate
bifoliate1444313bifoliate
biforate1346903biforate
bilobate1247033bilobate
binate8419773bi_nate
biotite9311033biotite
biplane1139033biplane
bistate9313823bistate
blate75933783__blate
bolete8519613_bolete
borate85026153_borate
bromate11313553bromate
bullate93415073bullate
chelate122914893chelate
cholates132414763cholates
ciliate9514603ciliate
ciliolate1145973ciliolate
cirrate92413493cirrate
citrate92216803citrate
collate92919683collate
comate104124843_comate
dealate83617843dealate
deflate113613943deflate
delate73827753_delate
desolate9411993desolate
dictate10311663dictate
dilated93115823di_lated
dilater83515653di_later
dilates83220663di_lates
dilute72911803di_lute
diorite8314913diorite
dioxane1565423dioxane
disrate81418523disrate
donate73619503_donate
elate55335883__elate
emulate9314123emulate
enolase7310193enolase
epilate9314283epilate
etiolated1047073etiolated
etiolates949213etiolates
evolute1045683evolute
faveolate15104623faveolate
fellate10313433fellate
filiate10414233filiate
fissate103010033fissate
fixate1638733fi_xate
folates103218453_folates
foliate10513533_foliate
foliolate1244873foliolate
foveolate15104293foveolate
gallate83417133gallate
gelate73421263_gelate
globate1057823globate
ideate7313683_ideate
idolater936863idolater
illite63414923_illite
immolate1246543immolate
inflate10312313inflate
ingate73018243_ingate
inlace82513043_inlace
inmate82917363_inmate
innate63917313_innate
insolate8311893insolate
iodated9310023_iodated
iodates8312903_iodates
iolites73819483_iolites
irate55627983_i_rate
isolated9410523isolated
isolates8613513isolates
late47560483___late
librate93214233librate
ligate72519253li_gate
ligulate92510253ligulate
limbate1139213limbate
lineate7815153lineate
lineolate946283lineolate
linoleate944733linoleate
liquate1638423liquate
lobate82915243_lobate
locate83919843_locate
malate84624563_malate
migrate101314173migrate
milage93414123mi_lage
millage103112753millage
misate81222693mi_sate
misdate101413963misdate
mismate111415353mismate
misrate91319143misrate
neonate7311333neonate
nictate9310223nictate
nidate7313783ni_date
niobates1037283niobates
niobite937953niobite
nitrate72017013nitrate
notate63217863_notate
oblate82214743_oblate
obovate1235463obovate
odonate848403odonate
oleate6318883__oleate
oolite63319603_oolite
orate55133303__orate
ovate84214393__ovate
overlate11716283overlate
ovulate1039453ovulate
oxalate1457623oxalate
ozonate1646863ozonate
palate84226793_palate
petiolate1149153petiolate
phonate12411813phonate
phorate12413363phorate
picrate112014143picrate
pileate93815923pileate
pillage103412603pillage
pinnate93613743pinnate
piolet83225643piolet_
piolets93513193piolets
pirate82322883pi_rate
pisolite10310373pisolite
plate74635113__plate
polite83625073_polite
prelate9519693prelate
priorate10411733priorate
probate11414483probate
pronate9418873pronate
prorate9418733prorate
reflate103516263reflate
relate64033633_relate
replate93420053replate
reslate73520593reslate
reviolated1446253reviolated
reviolates1347533reviolates
rotate63320343_rotate
sibilate1049533sibilate
sigmate10710143sigmate
silage72715303si_lage
silane62718053si_lane
simulate10311133simulate
sinuate7412163sinuate
situate7410783situate
slate55438283__slate
soilage8169353soilage
solace83415823_solace
solated83618023_solated
solates73523853_solates
solute64016663_solute
solvate102710213_solvate
spoliate1039243spoliate
stomate9313123stomate
stylate10179773stylate
sublate9315363sublate
thionate11137503thionate
tillage83111343tillage
tillite7313563tillite
tinplate1047743tinplate
titrate72215573titrate
togate74515683_togate
tolane64316583_tolane
toluate7159343_toluate
ululate749963ululate
vacate11314553v_acate
vacillate1456853vacillate
vacuolate1445223vacuolate
valuate102512733valuate
valvate133710813valvate
variate101316433variate
variolated1445403variolated
variolates1347463variolates
variolite1248083variolite
veloute1037733veloute
vexillate1944553vexillate
vibrated14228393vibrated
vibrates132210613vibrates
vibrato12247383vibrato
vicarate1378603vicarate
vicomte1445723vicomte
vidette1167543vidette
vigilante1343633vigilante
vilayet1348533vi_layet
vile76139803vi_l__e
villa85321233villa__
villager12267513villager
villages123010603villages
villain1038483villain
villas96117263villa_s
villatic1346233villatic
villose1038053villose
vintage11128143vintage
viol76523593viol___
violably1644923violably
violating1337443violating
violation1238443violation
violators1246583violators
violence1345713violence
violent102110813violent
violin9311983viol_in
violins10311453violins
violist10312143violist
violists1137663violists
violones1137383violones
viols86118103viol__s
virgates1237923virgates
virgulate1345233virgulate
visage1049083vi_sage
vitae84217633vi_ta_e
vitiated12289223vitiated
vitiates112311433vitiates
vittae93911003vitta_e
vivace1436553vi_vace
vizirate2045353vizirate
voila84813943voila__
voile84719723voil__e
volant9316323v_olant
volar86917413v_ola_r
volatile1146433v_olatile
vole75236983v_ol__e
volt76439533v_ol_t_
volta85215623v_ol_ta
voltage1136863v_oltage
voltes94915583v_ol_tes
volti84915963v_ol_ti
volts85421293v_ol_ts
volume11358273v_olume
voluted11297943v_oluted
volutes102710983v_olutes
vorlage1136403vorlage
vote74728623v_o__te
voyage1335473v_oyage
vulgate11388433vulgate
vulvate13388323vulvate
zeolite1638903zeolite
zincate1838533zincate
zonate154114923_zonate
zoolater1746093zoolater

Search took 8 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 Limit1340272826.79619721.5
3Display Results2822820.1102563.6
 (SQL Overall)1786912827.31224438.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.